|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 8th, 2008, 09:08 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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($V3TODAY,1,0) and then selecting my shading colour, having highlited the entire row, but nothing happened. Any help would be greatly apprecaited. 
|
|
#2
August 8th, 2008, 09:20 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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($V1TODAY(),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($V3TODAY,1,0) and then selecting my shading colour, having highlited the entire row, but nothing happened. Any help would be greatly apprecaited.
|
|
#3
August 8th, 2008, 02:39 PM
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($V1TODAY(),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($V3TODAY,1,0) and then selecting my shading colour, having highlited the entire row, but nothing happened. Any help would be greatly apprecaited.
|
|
#4
August 9th, 2008, 12:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 news  Marvellous - -thanks very much. I really appreciate that.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
