View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LUKEMUDGE LUKEMUDGE is offline
external usenet poster
 
Posts: 3
Default Change Cell Color Dependant On Date Range

I can work out the 'IF' argument to make words appear given a date range but
I would like the cells to change between Green, Orange and Red when a date
range is curren, upcoming(28days) and overdue when the sheet is updated and
using the NOW() function.