Forum Discussion
Excel Formula
Hi I am trying to create conditional formatting in my spreadsheet. I want the conditional formatting to show if the score has reached the % of the number. If it is above 60% then it needs to be green less than 60% needs to be red. the third row you can see is the score total and below are the scores for that test
1 Reply
Hi andrew stretton,
Select Conditional Formatting -> New Rule -> Use a formula to determine which cells to format
Put the formula mentioned below and select green color in the format.
=A$3*60%<A4
Do the same with ">" sign for red color.
