Hi Scott,

I think that you are trying just to give a value when there is an actual
number in cell A10 Right?

If so, this is what you should do:

=IF(A10="","",IF(A10=1,"True", "False"))

So what is actually doing is that the formula will only calculate the
condition if there is a number present. Another thing you might do too is to
play around with the "conditional formatting box" in word.

Hope that helps,


Vicente Tulliano
--
Vicente Tulliano


"Scott" wrote:

I'm trying to write a Conditional Formatting formula for cell C11, if the
number in Cell A10 is greater than 1.

I've been trying this without getting the results that I want:
=A10=1

This formula will fill cell C11, however when value in A10 is removed, C11
still remains with that fill, when I want it to be unformatted.

Any ideas?

Thanks