Share via

Excel Conditional Formatting (Excel for Mac)

Anonymous
2023-02-10T16:46:49+00:00

I have the following formula in a cell:

=(((U5+V5)/2)*O5*(1+(R5/100)))

I would like to set up conditional formatting for this cell, as follows:

When the solution to the formula is <G5, the cell has a green background,

and when the solution to the formula is >G5, the cell has a red background.

What I have done, which doesn't work, follows:

Click on the cell with this formula, then click on Conditional Formatting, then select New Rule.

Here are my selections:

Style: 2 color scale

For Minimum column:

Type: Formula

Value: I copy and paste =(((U5+V5)/2)*O5*(1+(R5/100)))<G5

Color: I select green

For Maximum column:

Type: Formula

Value: I copy and paste =(((U5+V5)/2)*O5*(1+(R5/100)))>G5

Color: I select red

I then click OK, and no background color shows up in that cell.

Currently, the value in the selected cell where I want the conditional formatting to show is $51.50,

and, the value in cell G5 is $71.00.

Thus, if this was working, I would expect the conditional formatting to make the cell green.

Finally, if you know what formula symbols to apply for less than or equal to, and greater than or equal to, that also would be appreciated.

TIA for your assistance.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2023-02-10T21:08:52+00:00

    Thanks, but unfortunately I cannot follow your directions.

    I do not know where to find 'Use a formula to determine which cells to format'.

    Sorry, I missed the fact that you're doing this on Mac.

    Does your user interface look different from this?

    Image

    0 comments
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-02-10T20:38:28+00:00

    My apologies, I should really stop answering questions about Mac (I'm on Windows).

    After selecting Conditional Formatting > New Rule..., select Classic from the Style drop-down.

    You should then be able to select 'Format only cells that contain' from the drop-down below that.

    0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-10T20:15:07+00:00

    Thanks, I have Excel v. 16.69.1, and after Conditional Formatting > New Rule,

    I have no idea where to find Select 'Format only cells that contain'.

    0 comments
  2. Anonymous
    2023-02-11T16:08:08+00:00

    So, that's where it is!

    Thanks. Solved.

    0 comments
  3. Anonymous
    2023-02-11T16:09:19+00:00

    No, but HansV MVP provided the place to look. Thanks!

    0 comments