![]() You can have the text stand out with italics, bold, or a certain color or have the cells highlighted with a specific color. ![]() Then, scroll down and select the action for the condition. For our example, we want to see when inventory is less than 50 units. On the Edit Rule screen, enter the condition. Select the one that applies we’ll pick Less than. Tap Add Conditional Highlighting at the bottom.Īs you can see, you have a variety of options for creating your rule for numbers like Is equal to, Greater than, Less than, or Between.Tap the Format button on the top right and select Cell.Select the cells, row, or column containing the number you want to highlight.Whenever inventory gets low, you want to be alerted when you view the sheet. Let’s say you have a product list spreadsheet containing inventory. So, we’ll start by setting up Conditional Highlighting for numbers. When using spreadsheets, you’re likely to have more numbers than any other type of data. Set up conditional formatting for numbers Make data pop with conditional formatting in Numbers for iPad.Use cell references and repeating rules.Set up conditional formatting for blank cells.Set up conditional formatting for durations.Set up conditional formatting for dates.Set up conditional formatting for numbers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |