CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaconditional-formatting
Nicola
Nicola

Reputation: 25

Conditional formatting in Google sheets not working

This should be about the simplest thing to do, but somehow conditional formatting is not working in my spreadsheet.

I just want the column N value to be highlighted according to the rules on the right, ie. if the value is below the weekly target highlight yellow; within the target range highlight pale green and above the target range highlight darker green. For some reason, the highlight is always yellow when a value is entered regardless of the value.

What am I doing wrong? I've made sure all the values in J, K and N are numbers.

Thank you!

enter image description here

Upvotes: 1

Views: 496

Answers (1)

Mike Steelson
Mike Steelson

Reputation: 15308

Add the equal operator in front of the address of cells

value is between =J3 and =K3

Upvotes: 2

Related Questions