Conditional Formatting for text

[nattiej101]

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).

[#2 · Accepted solution]

@nattiej101 

=K2="x"

You can try this rule for conditional formatting.

=$K$2:$AC$24

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