AnsweredAssumed Answered

Conditional Formatting Repeat?

Question asked by pademo57 on Jun 5, 2017
Latest reply on Nov 1, 2017 by keywords

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?

 

Thanks

Outcomes