conditional formatting in 07

A

AJB

I have a range of cells (c25:c29) that I want to highlight as an error when
their sum does not equal a number manually entered in cell n21. I have not
been able to figure out how to do this. Is this possible?

thanks
 
D

Dave Peterson

But you could select C25:C29 (and maybe N21)
then use:
format|conditional formatting|formula is
=sum($c$25:$c$29)<>$n$21
and apply a nice format.

But I'd use an adjacent cell. I think these are easier for most users to
understand.
=if(sum(c25:c29)=n21,"ok","Error!")

Another option would be to allow the users to enter what they need in C25:C28,
but use a formula in C29 that removes the check.

In C29:
=n21-sum(c25:c28)
 
T

T. Valko

Try this:

Select the range C25:C29
Goto Home tab>Styles>Conditional Formatting>New Rule>Use a formula to
determine which cells to format

Enter this formula in the box where it says: Format values where this
formula is true

=SUM(C$25:C$29)<>N$21

Click the Format button
Select the style(s) desired
OK out
 
Top