|PLEASE HELP! I'm stuck using excel 2003 :( I am wanting to flag a date with colors. I have beginning at cell F2, F3, F4 and so on set up as the in date. Cell G2 - infinity is set up as the completion date. What I would like to happen:|
when there is no completion date entered 10 days after the in date the completion date cell turns yellow.
If there is not a completion date entered 20 days after the in date the cell turns orange.
If no completion date 30 days after the in date the cell would turn red.
I'm sorry if I didn't explain what I'm asking for very well, but any help would truly be appreciated!! Thank you.