Help with cellIs
- Dominant language
- JavaScript
- Stars
- 15.5k
- Forks
- 2k
- PR merge metrics
- No merged PRs in 30d
Description
## 💬 Questions and Help
Hi, guys I'm kind of having some trouble when using the cellIs in conditional formating. I want to put a background color if certains cells equal "T". So for that I do these:
` {
type: "cellIs",
formulae: ["T"],
operator: "equal",
style: {
fill: {
type: "pattern",
pattern: "solid",
bgColor: { argb: "FFFF00" },
},
},
}`
I don't know if I'm actually doing the formulae part correctly. I couldn`t find a way to grab like the current cell and compare it.
Btw, I'm not using containsText because I have another rule that applies for when the cell value is "AT" so because of the 'T' being on both cells, one overrules each other.
Hope you can help and if if you can, could you please provide me with a better example for formulae ? Thanks
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.