<G

"Stevie_mac" wrote in message
...
There is a better way that will solve all your problems...

* Open VB (Alt+F11)
* Add a Module
* Paste the following function into the new module
Public Function HasFormula(target As Range) As Boolean
HasFormula = target.HasFormula()
End Function

Now you can use conditional formatting
Example...
Select cell B1
Open Conditional Formatting
In Condition1, select [Formula Is]
Enter =HasFormula(A1) as the condition
Set the format to make the cell RED & close Conditional Formatting
Test...
Enter =10/5 into Cell A1
See B1 go red
Enter "hello" into Cell A1
See formatting clear.

Good luck - Steve.



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