Conditional Formatting in Numbers not applying the rules
I am trying to set up pretty simple conditional formatting on a spreadsheet, to show numbers above 140 with a red fill and numbers below 110 with a blue fill. I have managed this successfully on previous spreadsheets so (sort of) know what I'm doing, but numbers is just not 'playing ball' this time.
As per historical posts on here, I have tried:
Saving and quitting numbers, then rebooting
Opening new document, copying & pasting spreadsheet
Referencing a cell (with the number 140) in the rule
Typing the text '140' in the rule
Nothing is working?!
Interestingly, I've just tried again to apply the 'less than 120' rule with a blue fill....and it has filled an EMPTY cell???
Can anyone help please?
I'm on MacBook Pro, macOS Catalina and Numbers v 11.1 - I can't update because I don't have room on the system for Monterrey 😣
Image shows first column where a different rule is being applied. The right hand column is the latest 'attempt' showing the filled empty cell?!
MacBook Pro 13″, macOS 10.15