How to Use Conditional Highlighting In Numbers For Data Visualization

[@frankadams4792]

I wish than Numbers would add a few things. One that I use all the time in the budget sheet I use in Excel is the Data Bars. Great for showing in cell the percentage that each expenditure is for the month and year. Since I have been using Numbers more in the last year or so I've built a better budget sheet in Numbers than the Excel one. Except that there are a few things that I wish I could do with Numbers. I have a small list of things I wish were added to the app. Data Bars, Slicers, put Filter back as a Function instead of a sidebar option, more category options in each field of the Pivot Table, Ability to lock Cells and/or Tables on a sheet. I do use Conditional Formatting in the Numbers and Excel budgets, but you showed a couple of things I didn't know and didn't think about. Thanks.

[@loisskiathitis8926]

Excellent! A very useful and informative video tutorial today! Thank you, Gary! 👏❤️

[@georgee3401]

Excellent tutorial. Very useful information. Many thanks!

[@blakee.robbins9130]

Hello! Quick question: is there a way to use conditional highlighting on a checkbox? I'm struggling to figure it out! HELP! 🙏

[@macmost]

Sure, though I don't know how useful it would be. You could check for "Cell" and "Is TRUE" or "Is FALSE" and then it will get that highlight when it is checked or not checked. But since you can clearly see the checkmark, I don't know how extra useful it is to also get a color or something like that.

[@blakee.robbins9130]

@ I see your point, however, I was expecting to make the entire line a particular color. 🤔

[@macmost]

@@blakee.robbins9130 Ah, I see. That's a very different thing and not easy to do. See kzbin.info/www/bejne/boacppV4fNiom5o

[@blakee.robbins9130]

@ Thank you! I'll check it out! 💥

[@warrenwells8905]

Very helpful! Thank you

[@kl9941]

Just fabulous Gary! Apple should be putting you on the payroll.

[@Pyxhel]

Awesome video ! How did you automatically insert the « $ » sign at 8:51 ?

[@stuartmcnair6696]

I think it was inserted 'automatically' when he clicked on the cell because it was a footer cell and not part of the 'data' cells.

[@Pyxhel]

@@stuartmcnair6696 That’s what I thought too

[@Erin-Thor]

Thanks for sharing your brain with us! ❤ There are a number (pun not intended) of things I can do in Excel that seem nearly impossible in Numbers. If you ever are bored (joke) consider going through things like parsing cell data, changing time formats, and data manipulation. For example we have a ROP (Routine Output Printer) that prints out outages and alarms, and needed to parse the output into a simpler spreadsheet format, and “speak” certain type of alarms, new alarms to the Mac’s speaker to draw attention to the alarm. Getting windows to do part of it was easy, until we got to the speaking specific text lines part. Also, Windows/Excel has a simple watch me feature to record a macro, is there anything on a Mac like that?

[@antongubenko8866]

Hi Gary is there any possibility to Sum numbers based on Cell colour, Example sum every number where cell colour is green( any colour condition).

[@macmost]

So you mean where you manually set the color? No. That's just decoration. You can't get that color as a value. So come up with another strategy instead. Like a checkbox in a column next to it. Or a sum based on the values on another column (SUMIF).

[@-_-ulyana]

Hi there. It was great tutorial. Could you please to share how to highlight a duplicate text in row/column in Numbers.

[@macmost]

kzbin.info/www/bejne/fmG5o6quoMqeoZY

[@PGOLiveSTREAMS]

Hi Gary, how can I convert a tick box to a value? I would like to use the blank as value 0, and a tick as the value of 1. Many thanks. Julian

[@macmost]

Do you mean visually see a number instead of a checkbox. Change the cell format to a number instead of a checkbox and then use 0 and 1 instead of true or false.

[@PGOLiveSTREAMS]

I need the check box to show as a tick, I would like to total the number of ticks at a footer box instead of manually counting

[@macmost]

@@PGOLiveSTREAMS Use COUNTIF for that. Checkboxes are true or false, so COUNTIF(B,true) would give you the total number of cells in column B that are checked.

[@PGOLiveSTREAMS]

@@macmost Thank you For you valuable assistance. I love watching your tutorials, they are so helpful.

[@FREIMUZIC]

great video!!! Thanks!

[@peterc2248]

Is it possible to format a cell based on the condition of another cell? For example, in my cashbook, I enter all values as positive numbers. In another cell I indicate whether the value is a debit (dr) or credit (cr). I would like to highlight debits as red text and credits as green text. Is that doable in numbers?

[@macmost]

So that other cell displays "dr" or "cr" already? Just use conditional highlighting based on whether the value is dr or cr. No need to refer to another cell.

[@LookNook2020]

Love your tutorials! 👍🏻 Can you please make a video about how to divide iPhone for work and play? I just got iPhone 14 pro max 1TB and I want to split my 2TB iCloud to keep my work related stuff separate-I’m getting so much conflicting advice my head is spinning 😵‍💫

[@macmost]

There's really no way to do a hard split. What is your goal in trying to do this? Just to make things nice? Or is there some corporate requirement?

[@LookNook2020]

@@macmost years an years of mess carried over from one phone to another… so much distraction. I was thinking to do iCloud family sharing on my account and sig-in as a second person to have the serious stuff separated from things that I need once in a blue moon and I could use airdrop for individual things if needed. Is that possible?

[@macmost]

@@LookNook2020 I suppose. Why not just use Focus modes though. You can switch to Work Focus and see only certain apps and then Home to see others.

[@LookNook2020]

@@macmost ⁉️ gosh I’m definitely not using my phone to it’s potential!! Will you do video about this please? Never used focus before-thank you

[@marcus1503]

If there away of if I put in ID 12 in to A1. B1 to J1 will fill is user information, I have to keep a meditcal log book and B1 to J1 could be fill in when I enter and ID code in to A1, I can not work out a =?? To do do this, Belonging for a way to be able to do this i and i not be able to find the right on, I think I would need Sheet2 if the data field so sheet 1 will take the information from there and ID 1 in A1 will fill out B1 to J1 for me. Is there a way of doing this. Thank You

[@macmost]

Maybe you are looking for the LOOKUP function? kzbin.info/www/bejne/gH68eX5re7-IoLc

[@dnshable]

I have been using Numbers on my iPad and just discovered that the number of rules for conditional highlighting is capped at 15. Why? We have such powerful hardwares and softwares, 15 is so small.

[@macmost]

I don't know for sure, but I'd say that any more and it kinda becomes useless. Yours table would be a mess of colors and it would defeat the purpose of spotting something with your eye that the highlighting is supposed to be calling out. In that case Conditional Highlighting is probably not the solution to whatever problem you are trying to solve. Something else like formulas, filters, categories or even another table is probably what you want. Hard to say without knowing your goal.

[@RORVS]

👋👋👋👋👋

[@BillSaltbush]

It's pretty clear that Emma has been spending too much time on doing a number(s)(?) on Daniel. Lift your game, Emma. Bill has too much time on his hands.

[@lllmmmppp]

Great video, this one pops up the most for what I am trying to solve in numbers.. I have no idea if you will see or respond to this but I have been pulling my hair out of my head all day. Do you know if there is a way to change a cells background color only(without changing the text in the cell), based on whether or not another cells check box is checked? I can't find the solution anywhere and it seems so simple but 8 hours later and I still can't figure it out. Is this even possible in Numbers? I'd be so grateful if you were able to help! Thank you kindly for your video. Further explained, I would like cell B2 to change its background color to orange if I check the box in cell B1.

[@macmost]

Not really, no. See these two videos: kzbin.info/www/bejne/qmq5k4ZueNdjf7s kzbin.info/www/bejne/Y2Xan2ljm5maiMk