Greetings to all.
I am trying to understand how formulas work when Conditional formatting. I have a date in cell E1(This date is not today's date). I also have a range of other dates in M4:M17. I would like to make whatever date is in cell E1 to be thought of as the current date. I would then like to formate any date in M4:M17 that is the same as the date in E1 to be Yellow. In addition I would aslo like to format any date in M4:M17 that is any time behind the date in cell E1 - this I would like to do in Red. Any help in accomplishing this would really be appreciated.