Thanks Steve,

I must admit I might use acronyms too liberally :-). The vice of the lazy I
guess.

I thought everyone knew UDF :-), but I know I shouldn't assume. As to CF, my
only(poor) defence is that the OP (original poster :-)) used the term
Conditional Format, so I thought the context gave it.

I will strive to be clearer, after all that is why we bother in the first
place <vbg

Thanks Again

Bob


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