Thread: Date Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cathy Cathy is offline
external usenet poster
 
Posts: 104
Default Date Range

Hello

I am trying to change the colour and display of a cell dependant on if a
date is within a range. If the range is 24/12/2007:30/12/2007 in A1 and the
date displayed is 26/12/2007 in B1, how do i get it to state in C1 that the
date was within the range, green or not red.

thanks