The way to do this is with Conditional Formatting. You would use the option to "Use a formula to determine which cells to format" and then use a formula like this:
and replace x with the percentage you want to check for. You would apply this rule from cell B2 to the lower right corner of your range, like Z3000.
If you have no experience at all with Conditional Formatting then feel free to ask for more details on the detailed steps.
It's always better to attach a file. I could just update your file for you if you do so.
Bookmarks