exceljs / exceljs/exceljs

Help with cellIs

Open
#1,318 3 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.