Thread: Change Cell Color Dependant On Date Range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
  
Posts: 703
Default Change Cell Color Dependant On Date Range
Hi

Look at "Conditional Formatting" on the Format menu.

Best regards,
Per

On 7 Maj, 04:15, LUKEMUDGE
wrote:
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.

Reply With QuoteReply With Quote