Forum Discussion

dfolk13's avatar
dfolk13
Copper Contributor
Mar 20, 2025

Conditional Formatting on Mac

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. 

Thanks a lot in advance and I appreciate the help.

Resources