Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community
SOLVED

Conditional Formatting for text

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

 

nattiej101_0-1671032073265.png

 

1 Reply
best response confirmed by nattiej101 (Brass Contributor)
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.

conditional formatting.JPG 

1 best response

Accepted Solutions
best response confirmed by nattiej101 (Brass Contributor)
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.

conditional formatting.JPG 

View solution in original post