Forum Discussion
Conditional Formatting
Hello, I’m way out of my element here. I have been tasked with doing a suspense tasker for assignments that need to be completed. I have been asked to set up formatting that will change a due date ...
Good morning,
Well I tried plugging in the formulas that you suggested and it worked, sort of. I skipped the first condition because it wasn't necessary. The third condition formula worked like I needed it to. But the second condition is coloring the cells yellow before it reached the 7 day mark. I have attached a screen shot to show you what I mean. I double checked to make sure I wasn't missing anything in the formula and its just as you wrote it. My co-worker says it's possessed. Any ideas?
Thanks,
Carol
The mistake was mine Carol! Try using this for the second formula instead:
=AND(7>=(C2-TODAY()),(C2-TODAY())>0)