Forum Discussion
nattiej101
Dec 14, 2022Brass Contributor
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).
- Dec 14, 2022
=K2="x"You can try this rule for conditional formatting.
=$K$2:$AC$24This is the range the formatting applies to in the example.
OliverScheurich
Dec 14, 2022Gold Contributor
=K2="x"You can try this rule for conditional formatting.
=$K$2:$AC$24This is the range the formatting applies to in the example.