How can I get my final average column grades below 65 to appear in the color
red?

See help on Conditional Formatting.


Gord Dibben MS Excel MVP

On Fri, 3 Jul 2009 14:33:01 -0700, r wrote:

How can I get my final average column grades below 65 to appear in the color
red?

Take the following action:-

1. In cell C 2 (for example) Format / Conditional Formatting . . .

2. The Conditional Formatting pop up window will launch.

3. Set the above pop up to:-

less than

65

Hit the Format . . . button and select Red in the Color: box

4. Click on OK.

5. You should now be back at the Conditional Formatting pop up window and in
here click on OK.

6. You can then copy the contents of cell C 2 to any other cell to which you
want the Conditional Formatting to apply.

Regards,
Steve.


"r" wrote:

How can I get my final average column grades below 65 to appear in the color
red?