Conditional Formatting + IF statement

[John]

Need some help w/ a formula. I'd like to highlight about
50 rows in a spreadsheet and state: If cell "Lx" (where
x=that row) is not blank, then shade the whole row gray,
otherwise do nothing.

I think I'm close, but just can't get it to work right.
Thanks for any advice.
John

 

[Frank Kabel]

Hi John
try the following
1. Highlight your all your 50 rows
2. Goto 'Format - Conditional format'
3. Enter the following formula
=$L1<>"" -> assumption row 1 is the first row of your selection
4. choose your format

HTH
Frank

 

[Frank Kabel]

O.K.
lets give it a try
1. Select all rows
2. Enter the formating for the row shading as described in the former
post:
=$L7<>""
3. Enter a second condition in the conditional format dialog:
=AND($G7=$F$2,$L7="") -> format this yellow/red
you can change the above to
=AND($G7=TODAY(),$L7="")

HTH
Frank

 

[Guest]

Outstanding. I love it. Thanks a ton for your help.

 

[Frank Kabel]

Hi
thanks for the thanks.
Frank