Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format whole row based on 2 rows
is it possible to format a whole row based on 2 cells with dates?
i would like to highlight the whole row if the second cell has already gone beyond the date of the first cell. for instance: cell B1 has 2/1/07 cell B2 has 1/30/07 cell D1 has 2/3/07 cell D2 has 1/25/07 i want to be able to set a condition for the whole D column without doing the tedious task of editing each row of D using Conditional Formatting. looking forward to everyone's reply. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format whole row based on 2 rows
CF/ Formula Is: =$D1$B1
-- David Biddulph "CTO" wrote in message oups.com... is it possible to format a whole row based on 2 cells with dates? i would like to highlight the whole row if the second cell has already gone beyond the date of the first cell. for instance: cell B1 has 2/1/07 cell B2 has 1/30/07 cell D1 has 2/3/07 cell D2 has 1/25/07 i want to be able to set a condition for the whole D column without doing the tedious task of editing each row of D using Conditional Formatting. looking forward to everyone's reply. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on other cells | Excel Discussion (Misc queries) | |||
Conditional Sum based on Bold Format | Excel Discussion (Misc queries) | |||
Conditional Format based on Other Cells | Excel Discussion (Misc queries) | |||
Conditional Format based on range | Excel Discussion (Misc queries) | |||
How do I set a Conditional Format for ROWs based on the value of . | Excel Discussion (Misc queries) |