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

Try this formula instead:

=AND(A10<"",A10=1)

Hope this helps.

Pete

On Feb 23, 5:57*pm, 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

What do you mean by "removed"?

If you delete the contents, then c11 should change to unformatted.

However, if you "remove" the cell by entering a space, then the conditional
format will apply because a space is greater than 1.

Clear the contents of the cell, or use "" as the value, then the conditional
format will not be triggered.

Regards,
Fred

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

Scott, it seems ok. Have you any other formatting that may be interfering
with the cell?
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"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

No, I shouldn't. I figured it out though.

This works:
=AND($A100,$A10<=1500)


"Russell Dawson" wrote:

Scott, it seems ok. Have you any other formatting that may be interfering
with the cell?
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"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

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