View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Justin Justin is offline
external usenet poster
 
Posts: 82
Default 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