excel formula?

Question

please help!

I am trying to get a worksheet to populate a final colour grade based on the final % score, so if its below 80 then it would be graded red, 81 - 90 then amber and 91 to 100 would be green, i have managed to do so with 2 grades but not all three, any help appreciated! thanks

Answer 1

Go to Format Menu -> Conditional Formatting...

In the dialog box, fill in all the conditions for each color and keep clicking the add button until you get all three conditions. Click OK to finish.

Use the Format Painter to copy this conditional formatting to other cells as needed.

Answer 2

You could enter conditional formatting in lthe cell.
You can also nest if,then statements.
If (cell