View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mtnmanus mtnmanus is offline
external usenet poster
 
Posts: 1
Default I want to change the cell format (color) based on a calc

I have a spreadsheet with due dates and current date - I want to change the
status on those tasks based on calculation of due date against current date.
If due date has passed - I want to turn cell "red", if not passed thenn
"green" if same day then "yellow".
How can I do this?
thanks !