This is amazing! I’ve been searching for these formulas for more than a year! I can’t thank you enough. Thank you so so much. I very much appreciate what you’ve done.
Great video thank you. In my case I want to have the text with a strikethrough with the checkbox unchecked, once checked the strikethrough would disappear but I cant seem to do this when I apply the conditional formatting. So what I did was apply text formating before starting your instructions and then followed through but could not remove it..
I have a checkbox in column E I know how to make check boxes and I know how to make it so if I check it I can turn column c red. What I dont know how to do is if I have a checkbox in E and also in F if just E is checked it is red if just F is checked it is blue but if both E and F are checked it turns Green. I have the checkbox values set to 5 so E=5 and F=5 but both E and F = 10 what is the formula to change the color of a column when 2 or more check boxes are checked
How would I do this if I have multiple checkboxes? I have 3 rows of checkboxes and each one that I check I want it to turn a different colour so I know what stage I'm at
Ik I'm super late and you are probably done with what you wanted to do but if not then you have to apply the formula to each checkbox since you want each one of them to turn to a different colour
Thanks For Watching! Click Below to Subscribe to Northern Viking Everyday. ruclips.net/user/northernvikingeveryday
Is is possibe to apply the formatting for the entire row and not just one cell?
For the formula, instead of doing something like =A2=TRUE, instead add a $ sign so it’s =$A2=TRUE and that should do the whole row
Thank you it works, I saw another video where it was "IF=H15=TRUE", but "IF" was unnecessary
Glad it helped
This is amazing! I’ve been searching for these formulas for more than a year! I can’t thank you enough. Thank you so so much. I very much appreciate what you’ve done.
Awesome 👍 Glad I could help you out.
This was a very helpful video. IT was able to help me after many failed internet searches.
Glad I could help 😃👍
Extremely helpful video indeed! Thank you for this!
Glad it was helpful!
Thanks for helping me figure this out!!
No problem 😀👍
Thank you! SUPER helpfull! Now I just need to learn how to add more columns.
You can do it!
So it only worked for one cell for me even thought i highlighted multiple cells to apply the rule to. could you help me with this please?
This was so helpful! Thank you! I am hoping to make an assessment tracker for my classroom with this option!
Glad it was helpful!
Obrigado amigo! Procurei vários vídeos na internet e o seu foi o mais explicativo e sem enrolação. Parabéns.
awesome video! Thank you!
You're very welcome 🤗
Valuable video. Thank you, man!
You're welcome 👍
Dude you rock! Thanks.
Glad to help!
You are awesome, friend, thank you!
Thank you for this tutorial. My question. Is it possible to lock the checkbox to prevent it from unchecked. Rgds
Great video, thank you!
You're welcome 👍
Thanks a lot!
You're welcome 👍
AMAZING THANK YOU
You're welcome 👍
Thank you sir
You're very welcome 👍
Thanks
No problem
thank you
You're welcome 😃👍
How do you sort by strikethru? I want to move my completed items all to the bottom as they check off
Great video thank you. In my case I want to have the text with a strikethrough with the checkbox unchecked, once checked the strikethrough would disappear but I cant seem to do this when I apply the conditional formatting. So what I did was apply text formating before starting your instructions and then followed through but could not remove it..
I have a checkbox in column E I know how to make check boxes and I know how to make it so if I check it I can turn column c red. What I dont know how to do is if I have a checkbox in E and also in F if just E is checked it is red if just F is checked it is blue but if both E and F are checked it turns Green. I have the checkbox values set to 5 so E=5 and F=5 but both E and F = 10 what is the formula to change the color of a column when 2 or more check boxes are checked
Is there a way to do this on the actual tickbox?
Thanks!!
You're welcome 👍
THANKYOU SO MUCH (caps intended)
You're welcome 👍
How do you add interactive comments to each line
Can this be done for individual students?
How would I do this if I have multiple checkboxes? I have 3 rows of checkboxes and each one that I check I want it to turn a different colour so I know what stage I'm at
Ik I'm super late and you are probably done with what you wanted to do but if not then you have to apply the formula to each checkbox since you want each one of them to turn to a different colour