Forum Discussion

nattiej101's avatar
nattiej101
Brass Contributor
Dec 14, 2022
Solved

Conditional Formatting for text

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

 

 

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

     

1 Reply

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

     

Resources