Hello,

I'm trying to set conditional formatting so that my spreadsheet has the
following colour code:

Cell Value Is equal to ="Low"
FORMAT = Fill Green

Cell Value Is equal to ="Medium"
FORMAT = Fill Yellow

Cell Value Is equal to ="High"
FORMAT = Fill Red

I know this sounds simple, but for some reason it's not working! I have
those values in the Conditional Formatting box, but when i type High it
doesn't highlight the cell red.

Is there something I'm doing wrong?

Many thanks,