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?

Try the Today() function instead of the Now() function...
--
HTH...

Jim Thomlinson


"travelinman" wrote:

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?

Thanks, I did a search and found that answer. I should have searched first.
But I appreciate your response.

"Jim Thomlinson" wrote:

Try the Today() function instead of the Now() function...
--
HTH...

Jim Thomlinson


"travelinman" wrote:

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?

Okay, I did something I should have done first ..I did a search and found the
answer to my question. Please ignore this post.

"travelinman" wrote:

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?