Hello everyone,

I have an issue, that i am trying to solve, and while spending two days browsing forums and help pages, i still haven't managed to find a viable solution for my case.

My issue is the following:

I am creating an excel sheet that uses conditional formatting to format cells, if the number inside them is between a defined range of values. I have 11 conditional format conditions. Now, this all works fine, but i am trying to make this possible for users that do not have any conditional formatting experience with excel, to be able to define in cells the range they want for each condition themselves. The coloring will not be variable, but the range will be. So it comes down to being able to have a single cell having a range of values and not a single value, so that then conditional formatting can look into that cell to see what it will format and how.

My problem is, that no matter how much i looked i haven't found yet a way to make a single cell have a range of numbers, without having those numbers pre-typed (as in A1 to A500 for example). This can be messy because the range i am looking at needs to contain 3 to 4 decimals, so typing in all those numbers even between 1 and 5 would be a mess.

I hope i explained my problem enough, and i am really eager to hear your ideas on this one.

Thanks for your time.

PS1: Multiple/nested IFs will not work as i have more than 7 conditions…maybe something with VLOOKUP?
PS2: I am working on a Mac, so no VBA code pls. (it is not possible to sue it here). I am just looking for a function to have all the numbers from 1 to 5 as a value in a single cell.