Just after choosing the icon put on established-for the selection, you really need to edit new laws so you’re able to establish such more viewpoints. To do that, choose one of the cells regarding Harmony column, check out Domestic > Conditional Format > Laws Manager and then click on the Edit Rule. The picture below reveals the new setup used in this case:
TIP: Among the best an effective way to discover how Icon Sets functions is always to explore all the various miss-off solutions on code configurations.
Just how to Have a look at/Edit Conditional Formatting Guidelines
Vertex42 has some themes that use each other easy and complex conditional format procedure. When you use a template and would like to ascertain how conditional formatting works, otherwise must erase otherwise change rules, you will need to know some things:
2) To gain access to All legislation regarding entire worksheet, find “It Worksheet” about miss-off towards the top of the principles Director windows.
The image a lot more than suggests the 5 laws included in the task Number Theme. The first laws change opportunities so you’re able to grey strike-due to when the Complete column enjoys a check mark. Next 3 rules focus on certain text regarding Concern column. The past code adds a development Pub on % Complete column.
I will be with this specific template to exhibit specific techniques and you can key points on conditional formatting, so i do suggest that you download it and you can try out it as you will still discover.
Rule Order Matters
- Conditional format rules was evaluated one after the other you start with this new signal noted on top.
- A later on rule don’t bypass the new format currently altered because of the an effective before signal.
Heavily weighed #dos means in case the very first signal has altered the fresh font colour so you can gray, the following laws you should never change the font color so you’re able to green, purple, or reddish. It’s earliest been, very first serve.
When you look at the Do well, new font colour and you can complete color (and you may border, and font concept, and you will . ) shall be impacted independently by additional rules. Thus you’ll have that rule you to definitely alter an excellent font to help you gray, an alternative rule one to alter this new cell color in 
order to yellow, and you may an alternate laws you to adds a document pub.
On the Prevent-If-Genuine field featured, none of your own following statutes would-be evaluated in the event the position of the very first code are fulfilled.
This is why the original activity line doesn’t let you know a data Bar in the %Done column and exactly why the new Priority “HIGH” is not emphasized red.
What can occurs basically failed to browse the Prevent-If-Correct container? Please try it . or look at the second picture.
Find the way the yellow complete colour are placed on this new Higher phone. The initial laws will not define a fill color, however it does change the font color. This means that brand new 4th code can transform the newest fill colour so you can light reddish, nevertheless can not override brand new font color.
Prosper versus. Bing Sheet sets: In the Excel, the quantity Structure, Font Colour, Font Concept, Font Underline, Font Effects, Fill Color, Fill Outcomes, Edging Colour, Border Layout, Investigation Pubs, and you can Icon Establishes will be inspired on their own of the other regulations. That isn’t the actual situation in Bing Sheets. In Google Sheets, conditional formatting behaves as though every regulations try Prevent-If-Correct. Prosper is more versatile and strong in that respect.
How to come up with an in-Phone Advances Pub
You’ve already seen how to incorporate a document Pub, so having fun with a data Bar for proving improvements considering a good fee is as simple as while making a few changes towards Investigation Pub options.