Hey Stevie,
@nd formula in vb works fine on single cell, If i clear the cell line in vb
it dont work at all.
What would be great is if you can detail how to do a columnSame cell Ref) in
many sheets.
Look forward to yr reply.

D.

"dave m" wrote:

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.