Hello
I have a sum formula result in A1.
I have a manual sum in B1.

If A1 = B1 then A1 to have a conditional white background, as if nothing
shows.

I tried using cond' format in cell A1..(if=B1=A1), select
format/pattern(white) for A1, but does not work.

Hope it is explained ok.

TIA
Terry

Cond Format Formula =if(a1=b1,a1), Then select Format- Font - White.

=IF(A1=B1,TRUE,FALSE)

Tyro

"Terry" wrote in message
...
Hello
I have a sum formula result in A1.
I have a manual sum in B1.

If A1 = B1 then A1 to have a conditional white background, as if nothing
shows.

I tried using cond' format in cell A1..(if=B1=A1), select
format/pattern(white) for A1, but does not work.

Hope it is explained ok.

TIA
Terry

Thanks...So simple when you know how..LOL

Regards

Terry
wrote in message
...
Cond Format Formula =if(a1=b1,a1), Then select Format- Font - White.

What if A1 and B1 are 0? 0 = logical FALSE

Tyro
wrote in message
...
Cond Format Formula =if(a1=b1,a1), Then select Format- Font - White.

If, in Conditional Formatting, you are using the "Formula Is" option, then
you don't need IF, because the formula is looking for a TRUE or FALSE
result. The formula is =A1=B1 [Remember to type the = sign at the
beginning of the formula, or else Excel gets confused.]

Alternatively you can use the Conditional Formatting "Cell Value Is" option,
and in that case choose Cell Value Is/ equal to/ =B1 [Again, remember to
put = before B1.]
--
David Biddulph

"Terry" wrote in message
...
Hello
I have a sum formula result in A1.
I have a manual sum in B1.

If A1 = B1 then A1 to have a conditional white background, as if nothing
shows.

I tried using cond' format in cell A1..(if=B1=A1), select
format/pattern(white) for A1, but does not work.

Hope it is explained ok.

TIA
Terry

Appreciated greatly...thanks David
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
If, in Conditional Formatting, you are using the "Formula Is" option, then
you don't need IF, because the formula is looking for a TRUE or FALSE
result. The formula is =A1=B1 [Remember to type the = sign at the
beginning of the formula, or else Excel gets confused.]

Alternatively you can use the Conditional Formatting "Cell Value Is"
option, and in that case choose Cell Value Is/ equal to/ =B1 [Again,
remember to put = before B1.]
--
David Biddulph

"Terry" wrote in message
...
Hello
I have a sum formula result in A1.
I have a manual sum in B1.

If A1 = B1 then A1 to have a conditional white background, as if nothing
shows.

I tried using cond' format in cell A1..(if=B1=A1), select
format/pattern(white) for A1, but does not work.

Hope it is explained ok.

TIA
Terry