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.
Want to know more about how to use Numbers on your Mac? Check out this MacMost course!
Comments: 10 Responses to “How to Use Conditional Highlighting In Numbers For Data Visualization”
Eric
7 months ago
I liked the use of the footer rows and functions combination in association with the conditional highlighting.
Michael
6 months ago
Thanks Gary. A brilliantly detailed tutorial. Regards Michael
John
6 months 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
6 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...
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
6 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
5 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.
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
4 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.
I liked the use of the footer rows and functions combination in association with the conditional highlighting.
Thanks Gary. A brilliantly detailed tutorial. Regards Michael
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.
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...
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.
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
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.
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.
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
Nick: Not sure if either conditional highlighting nor alternating row colors work with pivot tables. But keep experimenting.