Conditional highlighting for a cell that has Data Format as "Star Rating"

The function is available but it seems buggy if you click around in the data fields.

It is best to start clean, save and re-open the Numbers file and then proceed as follows

• Select the cells with the data (I assume it is all plain numbers or it won't work)
• Click on the format brush in the right upper corner
• Select the tab Cell and the cell formatting options appear
• Choose Data Format: Star Rating
• At the bottom of the cell formatting options click on the button Conditional Highlighting
• Select the green button Add a Rule and you get a pop-up to select your rule
• In the pop-up on the left side make sure you have selected 123 Number
• Select a rule like Greater than and enter a numeric value in the field that appears under Greater than
• Select a condition (i.e Green Fill)
• Above the rule click on the button Done

Now you should see the formatting.

That is easy, each start will return the number of stars that you select.

Use conditional highlighting for Number - Equal to

Hope this will help

Ralf

You are welcome, glad that I could help.

In some cases you can ask Numbers for a return value, add a new column and add this simple formula.

Column C is formatted as Automatic.