I think that that is what Tom and I were assuming in our replies. The
formulas and the result values are I presume in the same cell?

--
HTH

Bob Phillips

wrote in message
oups.com...
Thanks guys and I appreciate the replies... but it's very hard
sometimes to clearly state what the problem might be...

What was described above turns the cell with the formula a specific
color... I want the formula (or VBA) to turn the cell with the actual
numbers (i.e. A1, A2) a color based on the critieria.