Hi, i have a vlookup to a table that is linked to a access db that has both dates and percentages in it. when i do a simple vlookup the data is fine but i cannot do conditional formatting. however, if i change the vlookup to this
=VLOOKUP($E5,tblCurrent,4,FALSE)*1
the conditional formatting works but anything that is a date becomes a percentage. so 11/26/13 becomes 4160400%
i tried using the text function for the last part of the formula but it didn't work
any ideas?
thanks
Bookmarks