View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GeneWan GeneWan is offline
external usenet poster
 
Posts: 21
Default Conditional formatting with dates

Hi,

Did some searching online, but all the threads I stumbled upon are all using
reference to the current day "=today()"

Is it possible to only allow user to enter a date that falls within a range?
Eg. between 1/1/2010 and 2/1/2010. If the entry is not within the range, the
cell will be highlighted.

Thanks!