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)