Posted to microsoft.public.excel.worksheet.functions
|
|
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.
|