T trip_to_tokyo Jul 5, 2009 #3 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.
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.
