Conditional Formatting on Mac

Question

Hello,

I am having trouble with conditional formatting on mac. I would like there to be a gradient or tri-color conditional formatting on a specific column. I can get it to work with the numbers but not the formula when setting the rule. For example, I can get the scale to work by setting a min/mid/max number:

But I would like something more specific, like to have the red cells be percentages below 0%, white cells to be >0 and <= 10, and green cells to be >10%. However when I try to change this rule to a formula all of the cells turn white:

I have tried to change what it is applied to but nothing seems to work for the formulas. 

Answer 1

Don't use a graded color scale for this, but create two "classic" rules.

Set the fill color of the range to 'No Fill'.

On the Home tab, click Conditional Formatting > New Rule.
In the Style box, click Classic.
Under the Classic box, select 'Format only cells that contain'.

Leave the first drop-down set to 'Cell Value'
Select 'less than' from the second drop-down.

Enter =0 in the box next to it.

Click Format...

Activate the Fill tab.

Select red.

Click OK until the dialog boxes are closed.

Repeat these steps, but with 'greater than' instead of 'less than', with =0.1 and with green as fill color.