advanced conditional formatting help!!

  • Thread starter karldiffenderfer
  • Start date
K

karldiffenderfer

Here is what I am trying to do:

If the sum of 4 cells

E22 to E25

Equals D22

Then Color the text in:

E22 to E25 - Green

---------------------------------------

If the sum of E22 to E25

Does not equal D22

Then color the text in:

E22 to E25 - Red
 
R

Ragdyer

The exact formulas depend on what you presently have in those cells (empty,
formulas, formulas returning 0 or ""), so start with something like this,
and post back with any problems:

Select E22 to E25, then,
<Format> <Conditional Formatting>,
And change "Cell Value Is" to
"Formula Is"
And enter this formula:

=SUM($E$22:$E$25)=$D$22

Click on "Format" and set your font to a nice Green,
Then <OK>

Then, click on "Add" for your 2nd condition,
And again change "Cell Value Is" to
"Formula Is"
And enter this formula:

=SUM($E$22:$E$25)<>$D$22

Click on "Format" and set your font to a nice Red,
Then <OK> <OK>,
And you should be done!
 
Top