Conditional Formatting for text

Occasional Contributor

How would I create a conditional formatting formula/mass fill all cells that are NOT blank (all cells that have an x need to be green).




1 Reply
best response confirmed by nattiej101 (Occasional Contributor)



You can try this rule for conditional formatting.


This is the range the formatting applies to in the example.

conditional formatting.JPG