Hello all,
I have a complex w/sheet with daily sheets that runs a vlookup based on data
entered. once vlookup cells are populated with values, i copy,paste special
values to force the values into cells at the time of lookup.This prevents
data lookups showing old values on future days. Can i con.format cells so
that if they are vlookups they are 1 colour and another colour if values. I
have tried various formulas with no success and also tried referencing the
data elsewhere with no success. A curly one for frank, bob and max here me
thinks. Look forward to yr assistance as always.

Thanks, David.