In our company we use colour coding a LOT. So when I put something such as a level it needs to be coloured. As an example:
High is red
Medium is yellow
Low is green
Every time I try to add a conditional formatting the "Condition" always starts with "Value is" and "between".
I hardly ever use "Value is" but almost always use "Formula is". Is there some way I can change this so it opens with "Formula is" and as well as changing the "Self's" statement?
For that matter, once I have entered a condition in the upper window, is there some way to copy and paste it to the next line so I don't have to waste time repeating all the steps mentioned above?