Jun 12, 2017 Sadly, its not supported and Numbers for iPad strips out all the conditional formatting. If you edit the spreadsheet and send it back to your Mac Numbers or Excel, you'll have lost all the conditional formatting. As a side note, I've found the performance on conditional formatting even on my Mac to be terrible. Sadly, its not supported and Numbers for iPad strips out all the conditional formatting. If you edit the spreadsheet and send it back to your Mac Numbers or Excel, you'll have lost all the conditional formatting.
- Numbers App For Mac
- Numbers App For Mac Conditional Formatting Dates
- How To Download Numbers App For Mac
I have a Numbers spreadsheet, with 'quantity required' and 'quantity in stock' columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # in stock, i.e. you can only build one widget with the parts you have, and red when # required > # in stock, i.e. you can't build any widgets without first ordering parts. The problem is, Numbers seems to only want to take in individual cells in the conditional formatting box. Is there any formula to tell it, say, when in row 10, turn D10 red if B10 > D10, and the same, B12 and D12 for row 12, and so on, without having to go thru and program each row individually? Thanks for the help!
Chris
Numbers App For Mac
Chris
1 Answer
Created on a Windows machine but I'm hoping not an issue (though your Excel version might be), the image should indicate one way to achieve what I think you are asking for:
You mention 'to turn a cell' so Applies to here is to ColumnD only - A:D might be more useful, as may be adding green highlighting for parts where current stock is sufficient to service quantity required up to its ROP.
The formulae in conditional formatting rules use arrays, so no need for the tedious repetition your feared!
pnutspnuts
Not the answer you're looking for? Browse other questions tagged macworksheet-functionspreadsheetiwork-numbers or ask your own question.
Some of the content in this topic may not be applicable to some languages.
Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can format a whole cell range and vary the exact format as the value of each cell varies.
Temperature information with conditional formatting applied that shows top 10% and bottom 10% values
Temperature information with 3-color scale conditional formatting applied
Apply conditional formatting
-
Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
-
On the Home tab, click Conditional Formatting.
-
Do one of the following:
To highlight
Do this
Values in specific cells. Examples are dates after this week, or numbers between 50 and 100, or the bottom 10% of scores.
Point to Highlight Cells Rules or Top/Bottom Rules, and then click the appropriate option.
The relationship of values in a cell range. Extends a band of color across the cell. Examples are comparisons of prices or populations in the largest cities.
Point to Data Bars, and then click the fill that you want.
The relationship of values in a cell range. Applies a color scale where the intensity of the cell's color reflects the value's placement toward the top or bottom of the range. An example is sales distributions across regions.
Point to Color Scales, and then click the scale that you want.
A cell range that contains three to five groups of values, where each group has its own threshold. For example, you might assign a set of three icons to highlight cells that reflect sales below $80,000, below $60,000, and below $40,000. Or you might assign a 5-point rating system for automobiles and apply a set of five icons.
Point to Icon Sets, and then click a set.
More options
-
Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
-
On the Home tab, click Conditional Formatting.
-
Point to Highlight Cells Rules, and then click Text that Contains.
-
Type the text that you want to highlight, and then click OK.
-
Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
-
On the Home tab, click Conditional Formatting.
-
Click New Rule.
-
Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.
-
Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
-
On the Home tab, click Conditional Formatting.
-
Point to Highlight Cells Rules, and then click Duplicate Values.
-
Next to values in the selected range, click unique or duplicate.
-
Select the cell that has the conditional formatting that you want to copy.
-
On the Home tab (or the Standard toolbar in Excel for Mac 2011), click Format , and then select the cells where you want to copy the conditional formatting.
If only some part of your sheet has conditional formatting applied, you can quickly locate the cells that are formatted so that you can copy, change, or delete the formatting of those cells.
-
Click any cell.
If you want to find only cells with a specific conditional format, start by clicking a cell that has that format.
-
On the Edit menu, click Find > Go To, and then click Special.
-
Click Conditional formats.
If you want to locate only cells with the specific conditional format of the cell that you selected in step 1, select Same.
-
Select the cells that have the conditional formatting that you want to remove.
-
On the Home tab, click Conditional Formatting.
-
Point to Clear Rules, and then click the option that you want.
Tip: To remove all conditional formats and all other cell formats for selected cells, on the Edit menu, point to Clear, and then click Formats.
You can customize the default rules for conditional formats to fit your requirements. You can change comparison operators, thresholds, colors, and icons.
-
Click in the range that contains the conditional formatting rule that you want to change.
-
On the Home tab, click Conditional Formatting.
-
Click Manage Rules.
-
Select the rule, and then click Edit Rule.
-
Make the changes that you want, click OK, and then click OK again. Best free video screen capture software for mac.
Numbers App For Mac Conditional Formatting Dates
You can delete conditional formats that you no longer need.
-
Click in the range that contains the conditional formatting rule that you want to change.
-
On the Home tab, click Conditional Formatting.
-
Click Manage Rules.
-
Select the rule, and then click .
-
Click OK.
How To Download Numbers App For Mac
See also