Conditional formatting option add
So i noticed this really needs to be improved. When i want to highlight cells based on containing text in a list, there is no easy way to do it. WHy not? So i basically have to right out a detailed OR function. That is not good enough. So the solution is to go back to how it used to be. We choose to highlight cells containing 'C1' then click a button to add another underneath it and select 'C2' etc. Instead of having to add each one from scratch. Silly. Or you could create one that is based on highlighting if in a list of choices. There is no option for that. Should be easier to do this. why in the past did you have that layering and now you dont. Strange.