Home / Internet News / The right way to Use Conditional Formatting in Numbers on Mac

The right way to Use Conditional Formatting in Numbers on Mac

Conditional formatting in spreadsheets is an amazing characteristic that makes your knowledge stand out. You merely position prerequisites across the values in a mobile or workforce of cells. When the ones prerequisites are met, you’ll robotically have the mobile highlighted, the textual content formatted, or each. This makes particular knowledge pop.

If you want to arrange conditional formatting in Numbers on Mac, we’re right here to assist. As you apply this educational, be aware that during Numbers, the characteristic is known as conditional highlighting, moderately than conditional formatting.

Kinds of Knowledge for Conditional Highlighting

Earlier than including a rule for conditional highlighting, here’s a listing of the forms of knowledge you’ll use and the corresponding prerequisites.

  • Numbers: Equivalent to, no longer equivalent to, more than, more than or equivalent to, lower than, lower than or equivalent to, between, and no longer between
  • Textual content: Is, isn’t, begins with, ends with, comprises, and does no longer include
  • Dates: The day prior to this, nowadays, day after today, on this, within the subsequent, within the remaining, precisely, prior to, after, between, the date, prior to the date, after the date, and within the vary
  • Intervals: Identical choices as Numbers
  • Clean: Is clean or isn’t clean

For extra tactics to view your knowledge, you may additionally check out using interactive charts and graphs in Numbers How to Create Interactive Charts and Graphs on Mac Using Numbers How to Create Interactive Charts and Graphs on Mac Using Numbers Wish to visualize your knowledge? Numbers for Mac gives a characteristic for developing interactive charts and graphs and right here’s the way to use it. Read More .

Set Up a Conditional Highlighting Rule for Numbers

Numbers are the most well liked forms of knowledge you’re going to use in spreadsheets. Whether or not a easy quantity, cash, or share, numbers are in every single place in spreadsheets.

For putting in place conditional highlighting surrounding numbers, we’re going to make use of a product sheet for instance. This knowledge comprises numbers for worth, price, and stock, however we’ll be aware of stock.

Let’s say you wish to have to temporarily see when stock for a product falls underneath a certain quantity. As an example, 50. We’ll have Numbers spotlight the ones cells in purple. Right here’s the way to set this up.

  1. Make a selection the cells on your spreadsheet. You’ll make a selection a bunch through clicking the primary one and dragging thru the remainder or make a selection a whole column or row.
  2. Click on the Layout button at the most sensible proper to open the sidebar if it’s closed.
  3. Make a selection Mobile from the highest of the sidebar.
  4. Click on the Conditional Highlighting
  5. Click on Upload a Rule.
  6. Make a selection Numbers after which Lower than.

Conditional Highlighting Rule Numbers Less Than

Now you’ll customise your rule within the sidebar to use the formatting. Input the quantity (50) within the field beneath your situation (lower than) after which make a selection your formatting from the dropdown field (Pink Fill). You will have to see the adjustments right away when you’ve got values that meet the situation. Click on Executed.

Conditional Highlighting Rule Numbers Format

Set Up a Conditional Highlighting Rule for Textual content

Textual content is any other widely-used knowledge sort in spreadsheets. And for lecturers or professors who use Numbers for monitoring scholars’ grades, conditional highlighting is tremendous to hand.

So, for this case, we’ll use a grade sheet. Let’s say that each time a pupil receives an F on a check, we wish to spotlight that grade in yellow so we will be able to be offering them additional credit score. Right here’s the way to set this up.

  1. Make a selection the cells on your spreadsheet.
  2. Click on the Layout button at the most sensible proper to open the sidebar if it’s closed.
  3. Make a selection Mobile from the highest of the sidebar.
  4. Click on the Conditional Highlighting
  5. Click on Upload a Rule.
  6. Make a selection Textual content after which Is.

Conditional Highlighting Rule Text Is

Subsequent, customise your rule within the sidebar. Input the textual content (F) within the field beneath your situation (textual content is) after which make a selection your formatting within the dropdown field (Yellow Fill). As soon as once more, you’ll see the adjustments straight away for values that meet the situation. Click on Executed.

Conditional Highlighting Rule Text Format

Set Up a Conditional Highlighting Rule for Dates

The usage of dates in spreadsheets is perfect for such a lot of trade and private eventualities. From worker information to family budgets to project management The 5 Best Project Management Tips for Beginners The 5 Best Project Management Tips for Beginners If you’re taking over a undertaking supervisor function for the primary time, listed below are simply 5 undertaking control pointers that can assist you get began. Read More , when you’ve got dates in a spreadsheet already.

Probably the most very best tactics to make use of conditional formatting for dates is to make overdue dates for expenses stand out. So, that is our subsequent instance. We’ll arrange a rule for all Paid Dates which might be previous the Due Dates to show in purple textual content.

Right here’s the way to arrange conditional highlighting for dates that come after different dates.

  1. Make a selection the cells on your spreadsheet.
  2. Click on the Layout button at the most sensible proper to open the sidebar if it’s closed.
  3. Make a selection Mobile from the highest of the sidebar.
  4. Click on the Conditional Highlighting
  5. Click on Upload a Rule.
  6. Make a selection Dates after which After the date.

Conditional Highlighting Rule After the Date

To set this rule up simply, as an alternative of getting into a worth within the field beneath the situation, like a bunch or textual content, we’re going to make a selection the cells.

Click on the button within the field the place you might input a situation worth. Then, make a selection the cells that include the dates. Subsequent, click on the checkmark. Now you’ll see that every one Paid Dates which might be after the Due Dates have purple textual content. Click on Executed.

Conditional Highlighting Rule Date Cells

Set Up a Conditional Highlighting Rule for Intervals

Intervals will not be the most well liked forms of knowledge entries in Numbers, however should you organize initiatives or observe duties, intervals are to hand. And highlighting sure intervals is even handier.

For this case, we’re going to make use of a easy undertaking control activity sheet. Right here, we observe the time we spend on duties every week. Now, we wish to see the ones days the place we spent two or extra hours on a unmarried activity highlighted in inexperienced. Right here’s the way to set this up.

  1. Make a selection the cells on your spreadsheet.
  2. Click on the Layout button at the most sensible proper to open the sidebar if it’s closed.
  3. Make a selection Mobile from the highest of the sidebar.
  4. Click on the Conditional Highlighting
  5. Click on Upload a Rule.
  6. Make a selection Intervals after which More than or equivalent to.

Conditional Highlighting Rule Durations Greater Than or Equal To

Now, customise your rule. Input the length (2h) within the field beneath your situation (more than or equivalent to) after which make a selection your formatting within the dropdown field (Inexperienced Fill). Click on Executed.

Conditional Highlighting Rule Durations Format

Set Up a Conditional Highlighting Rule for Blanks

Yet another handy highlighting rule to arrange in Numbers is for clean cells. It’s good to use this in every of our examples above like lacking stock counts, pupil grades, and dates for expenses.

To turn you the way to arrange this rule, we’ll use our undertaking control spreadsheet and feature all clean intervals show in blue.

  1. Make a selection the cells on your spreadsheet.
  2. Click on the Layout button at the most sensible proper to open the sidebar if it’s closed.
  3. Make a selection Mobile from the highest of the sidebar.
  4. Click on the Conditional Highlighting
  5. Click on Upload a Rule.
  6. Make a selection Clean after which Is clean.

Conditional Highlighting Rule Is Blank

Subsequent, simply make a selection the highlighting sort from the dropdown field since there’s no worth so as to add beneath the situation. Click on Executed.

Conditional Highlighting Rule Blanks Format

Create Your Personal Customized Taste for Highlighting

Whilst the fundamental formatting choices are nice, like daring textual content or coloured cells, perhaps you wish to have one thing extra particular. Nice information, you’ll make your individual customized taste!

To create your individual taste, arrange your conditional highlighting rule the use of the stairs above. While you get to the phase the place you pick out the formatting from the dropdown field, move all of the solution to the ground of the field and click on Customized Taste.

You’ll then layout the textual content with daring, italics, underline, or strikethrough. And you’ll use colour for the textual content along with a colour for the mobile. So, this allows you to mix all types of formatting that fits your wishes very best.

In our instance underneath, for all undertaking prices which might be $20 or extra, our cells are formatted with yellow spotlight and purple textual content that’s additionally daring.

Conditional Highlighting Rule Custom Style Format

Take Good thing about Conditional Formatting in Numbers on Mac

With a bit of luck, this educational gets you off to a super get started in the use of conditional highlighting in Numbers for your Mac.

Do you occur to make use of two other computer systems and spreadsheet packages? As an example, perhaps you employ Numbers on Mac within the workplace and Microsoft Excel on Home windows at house. If that is so, take a look at our article on how to use conditional formatting in Excel Automatically Format Data in Excel Spreadsheets With Conditional Formatting Automatically Format Data in Excel Spreadsheets With Conditional Formatting Excel’s conditional formatting characteristic allows you to layout person cells in an Excel spreadsheet in accordance with their worth. We display you the way to use this for quite a lot of on a regular basis duties. Read More too.

Discover extra about: Mac Tips, Spreadsheet.

About tkpadmin

Check Also

But one more reason why the 2020 iPhone could also be definitely worth the wait – CNET

In these days’s roundup we are dissecting Apple’s newest patent submitting, which unearths new main …

Leave a Reply

Your email address will not be published. Required fields are marked *