You could add a function that tests the contents & changes the cell colour...

Open VB, then open Sheet 1

Paste the following in...

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.HasFormula Then
If Target.Value2 Like "=*" Then
Target.Interior.Color = RGB(255, 50, 50)
Else
Target.Interior.Color = RGB(255, 255, 255)
End If
End If
End Sub

Now when you type in A1, colour changes red if it is a function & green if not!



"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.