Go to Conditional Formatting on the Home tab of the ribbon. Select New rule > Use a formula to determine which cells to format. Then, type this one:

By using this formula in excel

=C3=1

Note that the reference of C3 is not absolute. Then, select to fill with red color on the fill tab and change font color (on the font tab) with the same color you filled the cell (this will make the number not visible). Do the same procedure for all points in the scale.

Finally, once you have all rules set, go to manage rules in the conditional formatting options and change the range of “Applies to” to select the entire desired range of application.

I can input a number and the cell will change colour also. Is there any way to do this method in google spreadsheets so i dont have to waste 10’s of hours. Thankyou

​Go to Conditional Formatting on the Home tab of the ribbon. Select New rule > Use a formula to determine which cells to format. Then, type this one:By using this formula in excel=C3=1 Note that the reference of C3 is not absolute. Then, select to fill with red color on the fill tab and change font color (on the font tab) with the same color you filled the cell (this will make the number not visible). Do the same procedure for all points in the scale. Finally, once you have all rules set, go to manage rules in the conditional formatting options and change the range of “Applies to” to select the entire desired range of application.I can input a number and the cell will change colour also. Is there any way to do this method in google spreadsheets so i dont have to waste 10’s of hours. Thankyou  Read More

​