Conditional Formatting

[Grammarjunkie]

Hi! Is there a way to do a conditional formatting so that if X cell has ANY value in it?
As in, just NOT blank?

Cell G8 I want to turn red if cell L3 has anything at all in it.
It's so simple, and I'm sure that there's something like, "L3="#value"" or some trick to do that. I just have never needed it till now so I haven't learned it.

Thanks!

 

[Joe4]

Try:

=L3<>""

or

=LEN(L3)>0

 

[Grammarjunkie]

Try:

=L3<>""

or

=LEN(L3)>0

Oh geeze.
Dur. Lol.

Yeah, that worked. Thanks again, Joe.

 

[Joe4]

Your welcome. Its like the old saying, "its easy when you know how!"