Conditional format an entire row based on one cell

W

Wagman V1

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.
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format Column based on Week Date 2
Conditional formatting row if cell value in certain column is even 1
change color of entire row by use conditional format 2
Changing entire row based on 1 MAX cell value (Conditional Formatt 2
[XL07] Conditionally format fill color for entire row 10
copy rows to new sheet based on specific cell value 4
How can I automatically color a row based on cell content 1
conditional format of entire row based on a single cell in row 7

Top