See help on Conditional Formatting.

Gord Dibben  MS Excel MVP

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.