Dear All, if anyone can give me the answer to this I’ll be very impressed, and grateful!
In LibreOffice Calc version 7.2.7.2 on a Mac I have a column of numbers in A1:A50. The contents range from 1 to 100, which change over time as the spreadsheet is used.
I want to create conditional formatting that changes the background colour of the cells if they contain certain specific numbers. So if, for example, the number 7 or 15 or 34 or 92 is present in the range A1:A50, those cells (and only those cells) get a green background. At the same time, if the range contains any of the numbers 16, 54, 78 or 100 the background becomes red. If the number 67 is present, that cell turns blue. Etc etc.
So this requirement is to check for specific numbers from a list, not evaluating whether the cells are higher or lower than a set criteria.
I’ve tried everything with this, and I’ve searched high and low for help with Conditional Formatting with a list of set numbers, but to no avail.
I’ve selected the range A1:A50 and set up Condition 1 so that if Cell Value Is Equal To 7 15 34 92, use the style selected below. And I did the same with Conditions 2 & 3 with their respective colours and styles, applying to the same A1:A50 range.
This didn’t work - no cells changed colour - so I tried Cell Value Is Equal To “7” “15” “34” “92”. Didn’t work either. I then tried Cell Value Is Equal To “7”, “15”, “34”, “92” (didn’t work) “7”,“15”,“34”,“92” (didn’t work) 7, 15, 34, 92 and finally 7,15,34,92.
Then I tried Formula Is: and put =OR(7,15,34,92) which made ALL numbers adopt a green background. No good. So I tried Formula Is =OR(“7”,“15”,“34”,“92”) which just put them all back to having a white background…
I’ve run out of ideas on this one. Can anyone shed any light on this? Is it possible for Calc to apply a set background depending on the specific number in a cell?
Your thoughts would be most appreciated.
Steve