Change Cell Color Dependant On Date Range

L

LUKEMUDGE

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Program buttons to create a word document 0
Using Color as Criteria in Countif Function 3
Change Cell Background 0
Remove Hyperlinks Without Changing background shading 14
Color change for Column Chart 4
Changing the color of a cell in excel based on due date 2
change colors in a range of excel cells based on another range of cells 1

Top