conditional formatting

[harvindersingh1]

Suppose I have certain numeric values in various cells like A1, B3, C2... and I am doing the total in cell F25. I want that if the total is coming more than 100 then the background color of the various cells whose totalling we are doing becomes red and if it is between 100-200 then it should turn blue and if more than 200 than it should become green.

[Paul]

I assume you mean that if it's under 100 you want red, since over 100 to 200 is blue and over 200 is green.

With that in mind, use conditional formatting like this (Format-->Conditional Formatting):

1. Using CTRL+click, select all of the cells that make up the sum in F25 (eg A1, A4, B7...)

2. Click Format --> Conditional Formatting

3. Click the 'Add>>' button twice to reveal all 3 condition options

4. In Condition 1, change Cell Value Is to Formula Is. In the formula box, type:
=$F$25>200

5. Click the Format.. button. On the Pattern tab, select Green and click OK

6. In Condition 2, change Cell Value Is to Formula Is. In the formula box, type:
=$F$25>=100

7. Click the Format.. button. On the Pattern tab, select Blue and click OK

8. In Condition 3, change Cell Value Is to Formula Is. In the formula box, type:
=$F$25<100

9. Click the Format.. button. On the Pattern tab, select Red and click OK

10. Click OK to close the Conditional Formatting window. Your formats should now be applied.