I just knocked up a test and it worked fine.

What does the VLOOKUP formula look like, and the CF formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Excel'ed Failures" wrote in
message ...
Hello Ladies and Gents.

I am having a problem with VLOOKUP and Conditional Formatting. What I am
trying to do is apply conditional formatting to the result of a formula.
I
have a list of serial numbers in column A. In Column B I have a VLOOKUP
formula that takes the serial number from column A and compares it to a
list
of serial numbers and dates imported from access in column C and D, taking
the date from column D. The result of this formula is a date that
corresponds to the same serial number found in columns A and C. I applied
a
conditional format to this date and it doesn't recognize that it is a date
at
all. When I type in the value the conditional format works correctly. I
tried to change the format to no avail. Does anyone have any insight to
my
problem? Thanks in Advance!

PS I dont want to type in over 500 dates just to get the conditional
formatting to work :(