Conditional formatting

Johfra

Johfra

Joined
Aug 30, 2012
Messages
13
Reaction score
0
If a cell contains ANY text, I want the background color to change. :o

All I've been able to find is if a cell contains a specific text (which I know how to do) but that's not what I want.

The texts will change constantly and there's nothing specific.

I tried:
=E24=""
=E24="ABC"
if(E24="")
if(E24="ABC")

None of them work....

Thank you for taking the time to read and/or help! :) :bow:
 
What you'll want to use is Conditional formatting and then use the following formula:

=IF(COUNTA(E24)=1,1,0)

That should do it. The easiest way to set this for a range is to select cell E24 and Click and drag to the last cell you want. Using the first cell you select in the formula for conditional formatting will allow the formatting to propagate through the range using the current cell as the reference for the formula.
 
Back
Top