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...
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.