conditional format help please

[Terry]

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

 

[alwaweru]

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

 

[Tyro]

=IF(A1=B1,TRUE,FALSE)

Tyro

 

[Terry]

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

Regards

Terry

 

[Tyro]

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

Tyro

 

[David Biddulph]

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

 

[Terry]

Appreciated greatly...thanks David

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

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