Conditional formatting question

[Sam Weber]

Greetings,

Is there any possible way to do conditional formatting
like this:

If cell value F* is filled with date, then format the
*whole* corresponding row into a grey color.

Currently, I can only see a way to do one cell a different
color if it's filled, and not the whole row including that
cell.

Regards,
Sam

 

[Ken Wright]

Select the whole row and then apply the conditional formatting using 'formula
is' rather than 'cell value is'.

 

[David McRitchie]

Select the whole row and then apply the conditional formatting using 'formula
is' rather than 'cell value is'.

AND use $ sign in front of the column letter but not in front of the row.
The reason is that each cell that is to be colored references the
needed C.F. formula(s).

More information on Conditional Formatting in
http://www.mvps.org/dmcritchie/excel/condfmt.htm

 

[Ken Wright]

LOl - Cheers for the clarification Dave

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Select the whole row and then apply the conditional formatting using 'formula
is' rather than 'cell value is'.

AND use $ sign in front of the column letter but not in front of the row.
The reason is that each cell that is to be colored references the
needed C.F. formula(s).

More information on Conditional Formatting in
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Select the whole row and then apply the conditional formatting using 'formula
is' rather than 'cell value is'.