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!

Signature
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> Here is what I am trying to do:
>
[quoted text clipped - 23 lines]
>
> Thanks
karldiffenderfer@gmail.com - 02 Sep 2006 23:05 GMT
PERFECT!!!! THANK YOU SO MUCH!!!
Ragdyer - 03 Sep 2006 08:55 GMT
Appreciate the feed-back.

Signature
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> PERFECT!!!! THANK YOU SO MUCH!!!