Step #7. Select the range G5:G52, in the home tab click conditional formatting, then click highlight cell rules, click equal to and type 5. To change the colour, click format with arrow and then click custom format, choose the 6th column, 6th row in the Theme Colors palette and then click fill and choose the 6th column, 3rd row in the Theme Colors palette
Step #7. Select the range G5:G52, in the home tab click conditional formatting, then click highlight cell rules, click equal to and type 5. To change the colour, click format with arrow and then click custom format, choose the 6th column, 6th row in the Theme Colors palette and then click fill and choose the 6th column, 3rd row in the Theme Colors palette
I want full vedio