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

Shading Rows With IF Statements? 5
Conditional Formatting Formula 2
Conditional format Column based on Week Date 2
Conditional Formatting Help 3
Conditiona format based on format of another cell 1
conditionally formatting 3
Cond. Formatting, Mod(Row) and cell conditions 2
Inserting a Copied Row inside a table 6

Top