I have a large spreadsheet and use conditional formatting to highlight the cell background of particular values (which are numbers). I have approximately 20 values that I need highlighted.
At the moment, I have a separate conditional formatting rule set up for each value I am interested in. However, it would be preferable if I could have a single conditional formatting rule/formula to do this, as the values I am interested in change from time to time and it would be faster to update a single formula.
Is it possible to do this?
For example, in my spreadsheet, I want to highlight any cell that has values 3, 42, 65, 87 etc.
Thanks in advance!
Bookmarks