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.

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.