conditional format help please

  • Thread starter Thread starter Terry
  • Start date Start date
T

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
 
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.]
 
Appreciated greatly...thanks David
David Biddulph said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top