1

In another post that is asking the same question that I ultimately have, the top answer says to conditionally format the cells using the formula ###,###. But when I go into conditional formatting, my only options are changing the Font, Border, and Fill of the text...nothing to do with the actual numbers. Help? Microsoft Excel 2016 Mac

Screenshot showing my only options: Font, Border, Fill

Sir Adelaide
  • 4,969
  • 2
  • 13
  • 36
amota
  • 35
  • 6
  • You've skipped a step. You need to format the cell with `###.##`, then apply a conditional format on the cell afterwards. – Michael Frank Apr 20 '17 at 04:31
  • Hey Michael, I've done a direct formatting of the cells to show 2 decimal places, like the first step says. Now, I want to conditionally format those cells to show only the whole number (without the decimals) when it is ###.00. The answer says to do that with conditional formatting, but I only get the option to basically 'color' the cells, not change decimal formatting. Any idea what I'm missing? – amota Apr 20 '17 at 04:48
  • Was about to write an answer when I see the tag `mac` and his screenshot – Vylix Apr 20 '17 at 05:50
  • I'm not an expert in Mac Office, but what the *Style* does? – Vylix Apr 20 '17 at 05:51

1 Answers1

2

As per your screen shot and other web examples, it appears that Excel 2016 for Mac can only format Font, Border and Fill.

From answers.microsoft.com:

Excel for Mac does not have the interface for number formatting in the Conditional Format dialog. The Mac version does respond correctly to Conditional Formatting generated in Excel for Windows.

Why? We can only guess as to Microsoft's thinking. It seems like a large omission.

Sir Adelaide
  • 4,969
  • 2
  • 13
  • 36
  • When I click "new rule" under conditional formatting, this is all I see. I don't see your "New Formatting Rule" dialog box with the "Format..." button. – amota Apr 20 '17 at 06:03