Immediately after choosing the icon put about dependent-in diet plan, you ought to edit the latest rule so you can determine such some other opinions. To do that, pick one of one’s tissues regarding Balance line, see Home > Conditional Format > Laws and regulations Movie director and then click to the Edit Laws. The image below reveals the fresh configurations included in this situation:
TIP: One of the recommended ways to find out how Symbol Kits really works would be to have fun with all the different shed-down selection regarding signal configurations.
Just how to Check/Change Conditional Format Legislation
Vertex42 has many themes which use both easy and state-of-the-art conditional formatting procedure. If you utilize a template and want to determine how the conditional format work, or should remove otherwise transform legislation, try to understand a few things:
2) To access All the rules from the whole worksheet, discover “That datingmentor.org/nl/daten-in-30/ it Worksheet” throughout the shed-down towards the top of the rules Manager screen.
The image over suggests the 5 guidelines included in the task Checklist Layout. The original code alter tasks so you’re able to gray strike-by way of when the Done line keeps a draw. The following step three legislation emphasize specific text on Consideration line. The very last code contributes an advancement Club on % Complete column.
Im with this theme to display certain processes and key facts on the conditional format, and so i carry out suggest that your obtain it and you may test out it as you will still see.
Code Purchase Matters
- Conditional format regulations try analyzed one by one starting with the brand new code detailed above.
- An after rule never override the newest formatting currently modified because of the good before signal.
Key point #dos ensures that if for example the basic rule has altered this new font color so you can grey, the second rules usually do not alter the font colour in order to eco-friendly, red-colored, or purple. It’s first become, first serve.
Into the Do just fine, brand new font color and you may fill colour (and you will edging, and font design, and you will . ) are going to be impacted on their own by the some other legislation. Thus you will get one signal you to transform good font in order to gray, a separate rule you to definitely alter the fresh cell colour in order to yellow, and you may an alternate rule you to definitely contributes a document pub.
Towards Stop-If-Real container checked, none of your own after the rules was analyzed whether your condition of these very first code was satisfied.
This is exactly why the first activity line cannot inform you a data Bar regarding %Complete line and exactly why brand new Top priority “HIGH” isn’t highlighted red-colored.
What can happens if i don’t take a look at Prevent-If-Correct field? Please check it out . or glance at the next image.
Observe how yellow complete color was applied to the brand new Large cell. The initial signal does not describe a refill colour, however it does replace the font colour. That means that this new last rule can transform the fresh new complete colour in order to light reddish, nonetheless it can not bypass brand new font color.
Do well versus. Google Sheets: Inside Excel, the amount Structure, Font Colour, Font Style, Font Underline, Font Effects, Complete Colour, Complete Effects, Edging Colour, Edging Layout, Studies Taverns, and you can Icon Sets are impacted individually because of the some other legislation. That isn’t your situation inside the Yahoo Sheets. Inside Yahoo Sheets, conditional formatting acts as though all of the laws is actually Stop-If-True. Do just fine is far more flexible and powerful due to that.
How to create an out in-Telephone Progress Pub
You already seen simple tips to add a document Bar, very using a document Bar to have proving improvements considering a great percentage is as simple as to make several change for the Study Pub options.