Subtracting two cell dates and highlight if over due by a certain amount of days

D

Desiree Stevenson

Joined
Aug 4, 2016
Messages
1
Reaction score
0
Hello I am not that good at excel and I am trying to highlight cells that have dates greater than a certain number of weeks to be either yellow, green or red

I'm trying to add two dates together in two different columns and if the outcome is greater than

21 days =hightlight yellow
Greater than 28 days = Hightlight Green
Greater than 14 days = hightlight Red

now sure how thats done in excel?
 
Last edited by a moderator:

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

Change Color of Cell based on Date and today's date. 1
How to figure out if a key is pressed in a cell of a table or a cellof a table lost the focus 6
Colour a row, based on a cell value 8
Matching Cell Colors (Cond. Formatting) 1
Conditionally format in code and count at same time 7
Excel check if dates are under a range of week 4
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
Function for days between dates and an if statement (HELP) 1

Top