Conditional Formatting + IF statement

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
Super, that did the trick. Now to up the ante...

(FYI, First row in range is 7).

Within the same range, I want to say (in addition to the
formatting you just provided below):

AND/OR, if Gx (where x=row) equals today's date (which is
dynamically provided in cell f2) then apply formatting
(color cell yellow w/ red border).

Both conditions could happen at the same time (in this
case, the row formatting of gray should override the date
formatting), or separately, or neither at all.

Thanks!!
John
 
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
 
Back
Top