Forum Discussion
Need help for conditional formatting with more than one specific text word
I need help to write a conditional formatting code for specific text. I have a worksheet with countif. I built a conditional format for specific text to color the cell a certain color, and the count...
Does that work for a range? I do not need it for one cell. I need it for a range of cells from A1 to EX1.
Excel automatically adjusts the cell reference. For B1, it looks at the value of B1, etc.
This is because the formula uses the relative cell reference A1.
If we had used the absolute cell reference $A$1, the rule would color all cells in A1:EX1 depending on the value of A1 alone.
- Thank you for the help.
It worked.
This is greatly appreciated.