Conditional format an entire row based on one cell

  • Thread starter Thread starter Wagman V1
  • Start date Start date
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.
 
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

Comparison of columns using Conditional Formatting 3
Shading Rows With IF Statements? 5
Conditiona format based on format of another cell 1
conditionally formatting 3
Conditional formatting row if cell value in certain column is even 1
Shade Cell based on condition 4
Conditional Formatting Help 3
conditional formatting using clock time 5

Back
Top