Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |