Conditional Formatting Formulas - Mystery Solved with 3 Simple Rules - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Fred
Wow, Mynda! Sorely needed here. No clue here about rule # 2. Have been setting up just one row then using Format painter to replicate the rest. Question: Is there a way to quickly replicate rules? I have custom shades for 3 different indications on a specific row. Doing 3 separate rules for each of 10 different rows gets tedious. Cutting and pasting helps up to a point, but all the clicking is a pain. Any suggestions? Thank you for all of your and Philip's contributions to the Excel community.
reply
Wow, Mynda! Sorely needed here. No clue here about rule # 2. Have been setting up just one row then using Format painter to replicate the rest. Question: Is there a way to quickly replicate rules? I have custom shades for 3 different indications on a specific row. Doing 3 separate rules for each of 10 different rows gets tedious. Cutting and pasting helps up to a point, but all the clicking is a pain. Any suggestions? Thank you for all of your and Philip's contributions to the Excel community.
reply
Jacek
My question is: why does Excel keep adding new ranges for a specified rule to be applied to? For one, when I specify that a rule should apply to a fixed range, I can see, after some time of using the spreadsheet, that there are multiple ranges the rule is ascribed to. This is a mystery to me. BTW: I love your videos, I can learn a lot from them. Thank you for your work.
reply
My question is: why does Excel keep adding new ranges for a specified rule to be applied to? For one, when I specify that a rule should apply to a fixed range, I can see, after some time of using the spreadsheet, that there are multiple ranges the rule is ascribed to. This is a mystery to me. BTW: I love your videos, I can learn a lot from them. Thank you for your work.
reply
Cloversmom
I would add #4 - don't forget to actually pick a format. I can't count the number of times I've entered my formula in the CF dialog and then clicked OK without actually selecting any format options, and then I can't figure out why my text looks the same. :) One of these days I'll learn..... (BTW thank you for your videos. They are all very helpful.)
reply
I would add #4 - don't forget to actually pick a format. I can't count the number of times I've entered my formula in the CF dialog and then clicked OK without actually selecting any format options, and then I can't figure out why my text looks the same. :) One of these days I'll learn..... (BTW thank you for your videos. They are all very helpful.)
reply
eduardo
Hi Minda, thanks for sharing.
I have 2 questions
.
1- I can use the same technique with a pivot table?
And how i can do it with a reference in de same column, let's say apply e conditioning format if all the value in a column's is less than 0..
2- wich program do you use to record and edit your videos ?
Thanks
reply
Hi Minda, thanks for sharing.
I have 2 questions
.
1- I can use the same technique with a pivot table?
And how i can do it with a reference in de same column, let's say apply e conditioning format if all the value in a column's is less than 0..
2- wich program do you use to record and edit your videos ?
Thanks
reply
chiwila
Thanks for this Mynda!! Can-t believe you were able to explain this so succinctly in just over 4 mins. You have cleared up A LOT of confusion I had as to how exactly this conditional formatting works. I will from now on always apply these 3 simple rules. It-s goodbye to the guesswork--. Thanks again!
reply
Thanks for this Mynda!! Can-t believe you were able to explain this so succinctly in just over 4 mins. You have cleared up A LOT of confusion I had as to how exactly this conditional formatting works. I will from now on always apply these 3 simple rules. It-s goodbye to the guesswork--. Thanks again!
reply
BC
Mynda, this is fantastic! I created a spreadsheet for when my medicines are due to be refilled... and it's set up almost similar as your book due spreadsheet. This conditional formatting would help me to visually see which meds are running out first. TY and I made sure to share your video!
reply
Mynda, this is fantastic! I created a spreadsheet for when my medicines are due to be refilled... and it's set up almost similar as your book due spreadsheet. This conditional formatting would help me to visually see which meds are running out first. TY and I made sure to share your video!
reply
Jim
I-m a CF fanatic & use it on almost every spreadsheet. 95+% are formula-based. Love that flexibility. But, oh, it was a painful learning curve (3-4 years ago). Hair-pulling is an apt description (except that my hair loss is mostly natural). Great lesson on a very useful feature!
reply
I-m a CF fanatic & use it on almost every spreadsheet. 95+% are formula-based. Love that flexibility. But, oh, it was a painful learning curve (3-4 years ago). Hair-pulling is an apt description (except that my hair loss is mostly natural). Great lesson on a very useful feature!
reply
Richard
I never really understood conditional formatting with formulas, and consequently found it frustrating and iterative. This video makes it so clear! Thank you for sharing it.
reply
I never really understood conditional formatting with formulas, and consequently found it frustrating and iterative. This video makes it so clear! Thank you for sharing it.
reply
Anastasios
Brief and at the same time to the point, explanative and precise! Your knowledge and command of excel is admirable! Thank you dearly, for sharing it with us dummies!
reply
Brief and at the same time to the point, explanative and precise! Your knowledge and command of excel is admirable! Thank you dearly, for sharing it with us dummies!
reply
Ricardo
Great one, actually know it and was able to use but the last step. how excel copy my formular across the cells in the background, is very helpfull to explain others.
reply
Great one, actually know it and was able to use but the last step. how excel copy my formular across the cells in the background, is very helpfull to explain others.
reply
Add a review, comment
Other channel videos
