Conditional Highlighting Gradient Fill

Hey I was just wondering if it is at all possible to have a gradient fill as a conditional highlighting rule.

Like for example if the cell contained a number greater than 50 it would have a gold/black gradient, if not a red/blue gradient.

Cheers, Derek M.

MacBook Air 13", macOS 10.14

Posted on May 13, 2019 5:32 PM

Similar questions

Conditional highlighting - This one is a suggestion for the Apple Numbers Team I guess the question is where can one make suggestion for future updates. One feature I've been dying to see, is conditional highlighting based on another cell. I have come across a few instances where it could be helpful, besides I don't see why such feature has not been implemented. Looks like it would be a small update, that wouldn't compromise much if any at all.
2064 4
Conditional highlighting with a color scale Is it possible with Numbers to use conditional highlighting with a color scale? I want colors to automatically change intensity based on the values in a selected cell range. However, I have two conditions for this: 1) I don't want the colors to be based on static value levels, but rather relative to the maximum and minimum values in the selected cell range. 2) I want a wide and continuous range of color intensities, ie not just a listed range of 5 or 10 levels or so. (Many other spreadsheet applications have this feature, eg Google Sheets) /R
3051 4
Conditional Highlighting How do I set up conditional highlighting for cells that are a specified % greater than comparative cell?
600 3

1 reply

Barry

Level 9

60,023 points

May 13, 2019 5:57 PM in response to DerekMcCarthy29

Hi Derek,

Not possible unless the option is offered in the Conditional Highlighting list. If so, it would likely be in the Custom Format section.

This may have been added in current versions, but the version I'm using (3.6.2) offers only singe colour fills.

Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Conditional Highlighting Gradient Fill

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up