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.
