Excel Conditional Formatting (Excel for Mac)

Question

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.

Answer 1

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?

Answer 2

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.

Answer 3

So you marked MeccaLeccaHi's reply as the answer?

Answer 4

I replied to MeccaLeccaHi that YOU provided the answer.

Now I have also answered the question accompanying your email,

"Did this reply solve your problem?"

with a YES. Thanks!

Answer 5

Thank you.