View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kim[_2_] Kim[_2_] is offline
external usenet poster
 
Posts: 3
Default COlor Coding specified time frames

I am attemtpting to use validation with date function. Example: I have a
booked date and a specimen date. I want the cell to turn a specific color if
the booked date and specimen date is 0-1 days, another color for 2-3 days,
etc. Is this possible? I can apply conditional formating to a date just one
day greater than my booked date. But that is as far as I can get with the
cell coloring.