I have cell that uses a vlookup formula to give me a date. (I.E. look for a
date in one cell and match it to a text statement and then add a number (1,
2, etc to it) based on the text. What I want is to conditional format (color
code) the cell so that if the date is less than, equal to or great than it
will change along with the date. I tried using the conditions based on a cell
with =now() formula. I am not getting the correct color format and I suspect
it is because the date format includes time but I am not sure. If I hard code
the date then the conditional format color code works. Are the any work
arounds short of hard coding the date?