Hey bob, I just realised, I suggested pretty much the same thing you did (see my 2nd reply)

Thing is, I looked at your solution yesterday but didn't actually make any effort to comprehend it. I simply looked at
it, thought that looks clever, don't have enough space in my brain to process it.

As it turns out, your solution was / is much better than my 1st suggestion (it is the correct way IMHO)

Why I didn't comprehend it (and quite possibly why Dave didn't use it) was I believe, because of the acronyms you used.

I now understand (since I came up with the same solution) that UDF = User Defined Function & CF = Conditional
Formatting.

I gotta say, there are times & places for acronyms (I use them myself - USB, TCP/IP) but these just threw me!

In my 2nd solution I think I used 1 acronym (VB) & but I'm pretty sure the guy will understand what I'm telling him to
do!

Anyway, for what its worth, just though I'd share!

TTFN - Steve.

(Ta Ta for now)

"Bob Phillips" wrote in message ...
You could write a UDF to test if a cell has a formula

Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function

and then use this UDF in the CF, like

=IsFormula(A1) for one colour

and

=A1<"" for the next

--
HTH

Bob Phillips

"dave m" wrote in message
...
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.