The way to use conditional formatting in numbers on Mac

Conditional formatting in spreadsheets is a superb function that distinguishes your knowledge. You merely place circumstances across the values ​​in a cell or group of cells. When these circumstances are met, you’ll be able to robotically spotlight the cell, formatted textual content, or each.

If you wish to configure conditional formatting in Numbers on Mac, we're right here to assist. Whenever you comply with this tutorial, notice that in Numbers, the function is named conditionally highlighted reasonably than conditional formatting.

Information Varieties for Conditional Highlighting

By including a rule for conditional highlighting, here’s a listing of the kinds of knowledge you should use and the corresponding circumstances.

Numbers : Equal to, equal to, completely different from, better than or equal to, lower than, equal to or lower than, between and never between
Textual content : Is, shouldn’t be, begins with, ends with, incorporates and doesn’t comprise
Dates : Yesterday, at this time, tomorrow, on this, within the following, within the final, precisely earlier than, after, between, the date, earlier than the date, after the date and within the 39, vary
Length : Similar choices as numbers
White : Is empty or shouldn’t be empty

You may as well view interactive tables and charts in Numbers to view your knowledge in quite a lot of methods.


The way to create interactive charts and graphs on Mac utilizing numbers




The way to create interactive graphics and graphics on Mac utilizing numbers

You wish to view your knowledge? Numbers for Mac supplies a function for creating interactive charts and graphs and explains how you can use it.
Learn extra

.

Setting a Conditional Spotlight Rule for Numbers

Numbers are the preferred knowledge sorts you’ll use in worksheets. Whether or not it's a easy quantity, cash or proportion, the numbers are ubiquitous in spreadsheets.

To set conditional highlighting round numbers, we are going to use a product itemizing for instance. These knowledge embrace numbers for worth, value and stock, however we are going to concentrate on shares.

Suppose you wish to know rapidly when shares of a product fall beneath a specific amount. For instance, 50. We may have Numbers spotlight these cells in purple. Right here's how you can configure this.

Choose cells in your spreadsheet. You possibly can choose a bunch by clicking on the primary and dragging the remainder, or by choosing a column or a whole row.
Click on the Format button on the prime proper to open the sidebar whether it is closed.
Choose Cell on the prime of the sidebar.
Click on on Highlighting Conditional
Click on Add Rule .
Choose Numbers then Lower than .

Now you can customise your ruler within the field to use formatting. Enter the quantity (50) within the field comparable to your situation (lower than), then choose your formatting from the drop-down listing (Crimson Fill). You must see the adjustments instantly when you have values ​​that meet the situation. Click on on Completed .

Setting a Conditional Highlighting Rule for Textual content

Textual content is one other sort of information that’s broadly utilized in spreadsheets. And for lecturers who use Numbers to trace pupil grades, conditional highlighting is extraordinarily handy.

So we are going to use a sheet of notes for this instance. Let's say that each time a pupil receives an F throughout a take a look at, we wish to spotlight this notice in yellow in order that we are able to provide him extra credit score. Right here's how you can configure this.

Choose cells in your spreadsheet.
Click on the Format button on the prime proper to open the sidebar whether it is closed.
Choose Cell on the prime of the sidebar.
Click on on Highlighting Conditional
Click on Add Rule .
Choose Textual content then Is .

Then, customise your rule within the field. Enter the textual content (F) within the field underneath your situation (the textual content is), then choose your formatting from the drop-down listing (Yellow Fill). As soon as once more, you’ll instantly see the adjustments for the values ​​that meet the situation. Click on on Completed .

Setting a Conditional Highlighting Rule for Dates

Utilizing dates in spreadsheets is right for a lot of private and work conditions . From Worker Information to Family Budgets to Venture Administration


High 5 Venture Administration Suggestions for Rookies




High 5 Venture Administration Suggestions for Rookies

When you tackle a challenge administration function for the primary time, listed here are 5 challenge administration tricks to get you began.
Learn extra

You most likely have already got dates in a spreadsheet.

Among the best methods to make use of conditional formatting for dates is to spotlight outdated expiry dates. So, that is our subsequent instance. We are going to outline a rule for all previous cost dates and show them in purple.

Right here's how you can set conditional highlighting for dates after different dates.

Choose cells in your spreadsheet.
Click on the Format button on the prime proper to open the sidebar whether it is closed.
Choose Cell on the prime of the sidebar.
Click on on Highlighting Conditional
Click on Add Rule .
Choose Dates then After the date .

To set this rule simply, as a substitute of coming into a price within the field underneath the situation, akin to a quantity or textual content, we are going to choose the cells.

Click on the button. Button contained in the field the place you’ll be able to enter a situation worth. Then choose the cells that comprise the dates. Then click on on the checkmark . Now you can see that every one dates paid after the due dates have a purple textual content. Click on on Completed .

Configure a Conditional Highlighting Rule for Durations

Durations might not be the preferred kinds of knowledge entry in Numbers if you happen to handle initiatives or comply with duties, the durations are sensible. And to emphasise sure durations is much more sensible.

For this instance, we are going to use a easy challenge administration job sheet. Right here we comply with the time we spend on duties each week. Now, we wish to see the times we spent two hours or extra on a single job highlighted in inexperienced. Right here's how you can configure this.

Choose cells in your spreadsheet.
Click on the Format button on the prime proper to open the sidebar whether it is closed.
Choose Cell on the prime of the sidebar.
Click on on Highlighting Conditional
Click on Add Rule .
Choose Length then Better than or equal to .

Now customise your rule. Enter the length (2h) within the field comparable to your situation (better than or equal to), then choose your formatting from the drop-down listing (Inexperienced Fill). Click on on Completed .

Setting a Conditional Highlighting Rule for Blanks

One other extra handy spotlight rule to set in Numbers is for empty cells. You should use this in every of the examples above, akin to lacking inventories, pupil grades, and bill dates.

To point out you how you can configure this rule, we are going to use our challenge administration spreadsheet. empty occasions are displayed in blue.

Choose cells in your spreadsheet.
Click on the Format button on the prime proper to open the sidebar whether it is closed.
Choose Cell on the prime of the sidebar.
Click on on Highlighting Conditional
Click on Add Rule .
Choose Virgo then Is a virgin .

Then, merely choose the spotlight sort from the drop-down listing as a result of there isn’t any worth so as to add within the situation. Click on on Completed .

Create your personal customized model for highlighting

The essential formatting choices are appropriate, akin to daring textual content or coloured cells, maybe you need one thing extra particular. Excellent news: you’ll be able to create your personal customized model!

To create your personal model, configure your conditional highlighting rule by following the steps above. Whenever you get to the half the place you select formatting from the drop-down listing, go to the underside of the field and click on on Customized Type .

You possibly can then format the textual content with daring, italic, underline or strikethrough. And you should use the colour for the textual content along with a coloration for the cell. This lets you mix all types of layouts that greatest meet your wants.

In our instance beneath, for all challenge prices over $ 20, our cells are formatted with yellow highlighting and daring purple textual content. .

Profit from conditional formatting of numbers on Mac

We hope this tutorial will enable you get began utilizing conditional highlighting in Numbers in your Mac.

Do you employ two completely different computer systems and spreadsheets? For instance, it’s possible you’ll be utilizing Numbers on Mac within the workplace and Microsoft Excel on Home windows at house. If that’s the case, see our article on utilizing conditional formatting in Excel


Mechanically format knowledge in Excel spreadsheets with conditional formatting




Mechanically format knowledge in Excel spreadsheets with conditional formatting

The Excel Conditional Formatting function lets you format particular person cells in an Excel spreadsheet based mostly on their worth. We present you how you can use it for varied duties of on a regular basis life.
Learn extra

too.

Be taught extra about: Mac Suggestions, Spreadsheets.

The 10 Greatest iMac Equipment in 2019

Related posts

Leave a Comment