Conditional Formatting with reference to Sum of Other Cells

[Ujjwal048]

Using Excel 2007,

I need conditional formatting for Column A, For Cell A1, if sum(C1:G1)>10, Cell A1=Red, if sum(C1:G1)<10, Cell A1=Blue and So on for Cell A2, A3, A4 .....

Any help would be very appreciated!!

File attached!!!

[Ace_XL]

Use two rules for column A

=SUM($C1:$G1)>$A1 -- Format red

=SUM($C1:$G1)<$A1 -- Format Blue

[JohnTopley]

Try

=SUM(C1:G1)>A1 red

=SUM(C1:G1)<A1 Blue

Select required range in column A and do CF with "Use formula to determine which cells to format" and enter the two formula above.