Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating and auto filling
I have 2 columns with dates in them, I want to change colour of the 2nd date
dependant on the 1st. I can do that no worries but when I try to fill it downwards all the cells will look at the first cell I set the condition to rather than the adjacent cell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating and auto filling
Change absolute reference to relative reference. From your conditional
formatting formula remove the $ sign from the row. Suppose if it is $D$1 change that to $D1 If this post helps click Yes --------------- Jacob Skaria "Justin" wrote: I have 2 columns with dates in them, I want to change colour of the 2nd date dependant on the 1st. I can do that no worries but when I try to fill it downwards all the cells will look at the first cell I set the condition to rather than the adjacent cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filling | Excel Worksheet Functions | |||
Auto filling a row | Excel Discussion (Misc queries) | |||
auto filling question | Excel Discussion (Misc queries) | |||
Auto FILLING/UPDATE | New Users to Excel | |||
Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) |