Conditional format an entire row based on one cell
 

Is there any way to have an entire row shaded based on a value in that row. I
want rows to be shaded once if a date in the row has passed.

I have tried using the =IF($V3<TODAY,1,0) and then selecting my shading
colour, having highlited the entire row, but nothing happened. Any help would
be greatly apprecaited.

Conditional format an entire row based on one cell
 

Try it this way (steps in xl2003)

Select the entire sheet (A1 active),
then apply Conditional Formatting using Formula Is:
=AND($V1<TODAY(),ISNUMBER($V1))
Format the fill color, etc to taste Ok out

Test it out .. Input a real date earlier than today's date anywhere in col
V, and the entire row will be conditionally formatted
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"Wagman V1" wrote:
Is there any way to have an entire row shaded based on a value in that row. I
want rows to be shaded once if a date in the row has passed.

I have tried using the =IF($V3<TODAY,1,0) and then selecting my shading
colour, having highlited the entire row, but nothing happened. Any help would
be greatly apprecaited.

Conditional format an entire row based on one cell
 

Marvellous - -thanks very much. I really appreciate that.

"Max" wrote:

Try it this way (steps in xl2003)

Select the entire sheet (A1 active),
then apply Conditional Formatting using Formula Is:
=AND($V1<TODAY(),ISNUMBER($V1))
Format the fill color, etc to taste Ok out

Test it out .. Input a real date earlier than today's date anywhere in col
V, and the entire row will be conditionally formatted
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"Wagman V1" wrote:
Is there any way to have an entire row shaded based on a value in that row. I
want rows to be shaded once if a date in the row has passed.

I have tried using the =IF($V3<TODAY,1,0) and then selecting my shading
colour, having highlited the entire row, but nothing happened. Any help would
be greatly apprecaited.

Conditional format an entire row based on one cell
 

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"Wagman V1" wrote in message
...
Marvellous - -thanks very much. I really appreciate that.