Conditional Formatting help!

New Contributor

Hello community,


I'm trying to figure out how to utilize the conditional formatting feature for my sheet.


This is what a part of my data looks like:

Screenshot 2022-12-21 at 10.27.44 AM 1.png


I want the "Average" columns to highlight in a red box if the values are less than 3.5 (for example). As you can see, the "Average" columns can be found in columns M, N, and O and I only want to highlight the values of "Average" in columns M, N, and O, and nothing else.

But when I try selecting all columns M, N, and O and apply conditional formatting "Highlight Cells Rules" > "Less Than" and select below:
Screenshot 2022-12-21 at 10.33.50 AM.png


Then, this is what happens:
Screenshot 2022-12-21 at 10.33.19 AM.png


- What do I need to do if I don't want to highlight the boxes with no value (empty boxes)?
- What do I need to do if I don't want it to highlight the "Percent" values? I want "Average" only.


If you know how to work with this feature, please guide me on the path! Thank you so much in advance!

3 Replies


Select only M8:M11, N17:N26 and O32:O33 when you create the rule.

Hi Hans,

Thank you. That's a good way when you work with small data (manually selecting each section). However, I'm here dealing with hundreds of data like this and the screenshot I posted is just a part of it and it's impossible for me to go down the data and manually select like this. I was hoping to see if there's a way to do this in an easier way when dealing with huge chunks of data.

Thank you!


I'm afraid you'll have to do that...