How to Use Conditional Highlighting In Numbers For Data Visualization

You can use Conditional Highlighting to make numbers stand out in your spreadsheets. If you combine them with functions like RANK, LARGE, SMALL and more you can see useful information in your tables at a glance.

Comments: 10 Responses to “How to Use Conditional Highlighting In Numbers For Data Visualization”

    Eric
    1 year ago

    I liked the use of the footer rows and functions combination in association with the conditional highlighting.

    Michael
    1 year ago

    Thanks Gary. A brilliantly detailed tutorial. Regards Michael

    John
    1 year ago

    Thanks. I’ve used Numbers for years but never knew about conditional highlighting nor the functions Large and Small. I also didn’t know about being able to see the descriptions for the functions in the pane at right. I guess I started using Numbers early on when it was less functional and never kept up.

    David
    12 months ago

    Great Tutorial, Thankyou Gary.
    I have been getting into numbers on and off for 6 months now. Enjoying the tips. hopping you can put together a tutorial on how to create a detailed sports league spreadsheet, particularly rugby league with details of such things as team stats, and player stats? I just cant get my head around how to set it up...

    12 months ago

    David: Think about how you would do it on paper. Start there. Then once you have that as a table in Numbers, you can build on it with highlighting, sorting, filters, formulas, etc, on an as-needed basis.

    David
    12 months ago

    Good tip. thanks for getting back to me Garry. I started by downloading the fixtures table for the games, and I put in the one cell drop down and stepper menus (1 for round) and 1 for (team) like you show how to do in your vids then got someone to build me a script to give me results and stats every week. but I was having trouble linking all the info, together. So last night I wrote down what I was trying to solve (I have watched nearly all. of your numbers vids) and its really helped me. cheers

    Steve Bragg
    11 months ago

    Just went back to this video for some work I'm doing with conditional highlighting. Is there any way to make the conditional highlighting in a cell permanent? I have some cells bolded based on another cell and I would like to keep the bold but delete the column upon which the highlighting is conditional.

    11 months ago

    Steve: Just format the cell as you would normally format it using the Format, Style, Fill or Format, Text. Or, maybe consider keeping the column, just hide it.

    Nick Tessitore
    11 months ago

    Great tutorial. I tried to use the learnings on a pivot table, but could not find the create conditional highlighting section. Is that possible? If so how do I find it? Similar question on pivot tables … I can’t find the alternate row colors, like a table is able to do. I have Googled for answers and can’t seem to find an answer.

    Thanks Gary

    11 months ago

    Nick: Not sure if either conditional highlighting nor alternating row colors work with pivot tables. But keep experimenting.

Comments Closed.