I don't know how to re-open a question so I am just asking it again.
I don't know why I can't get this to work right, but when the conditional formatting won't copy over correctly to other columns/cells.
I would really appreciate help. I have to work with other date diffs too but I can't even get these basic ones to work...
What I need on the attached sample worksheet is:
FOR COLUMNS C, D & E
1. IF DATE => 24 MOS FILL RED
2. IF 23 MOS =< DATE =< 24 MOS FILL YELLOW
3. IF CELL IS BLANK CLEAR FILL
4. DEFAULT CELL FILL GREEN