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...
1. Define 'Keywords' as a named item:
2. Conditional Formatting formula will then be:
=XOR(A$1=Keywords)- How does that work for a range of cells from A1 to EX1?
Nothing changes. Be sure to select the range you want the conditional formatting to apply to and use the correct referencing styles:
