conditional format help please
 

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

conditional format help please
 

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

conditional format help please
 

=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

conditional format help please
 

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.

conditional format help please
 

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.

conditional format help please
 

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

conditional format help please
 

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