⚡ If you want to test conditional formatting in Excel, you can access the spreadsheet that I used in the video here: 1drv.ms/x/s!AmxrofZZlZ-wg_9oT7UzsR6aXkkSDQ 🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Hey Kevin. Cool video. How do you use conditional formatting for accounting. For example if I want to change the font color if the expense are greater than the revenue to red.
The information of condutional formating which you gave to us is so limited and basic level. Its functionality is so huge. I’ m looking forward to advanced level of it 👍 Thank you
As somebody who was looking on guidance to more advanced topics, I should say that this is still invaluable to people who are not used to conditional formatting. I do wish the title could point out this is for basics, but it is still very useful.
Hey Kevin the video was amazing I m a student and had my computer practical’s tmr and the video really helped me nd can u please post videos on basic python programming it would be really great
I can only congratulate you and your tutorials they are so easy to understand for the older generation. I wonder if I could ask for a tutorial , I have lists of three column first column is a number, second column is a name, third column is either a Y or N ( yes or No ) Is there a way to total all of the number values with a Y's or N's in the list
Hi Kevin, I love your videos but am still learning on how to expand and use Excel in a bigger way. With that said, I am creating a simple project tracker spreadsheet for all my supervisors so I can keep track of project status and trying to use the strikethrough feature for completed items. I watched a video on how to do this but the video only explained how to do this for one row. I would like to apply this to the entire worksheet without having to create a rule for every individual row( worksheet contains 250 rows :( Please HELP!!
Hi Kevin. How do you format a list of numbers when compared to another list of numbers, ie compare each value on a line to one on the same line, without doing a separate format for each one?
I want to use Excel as a reminder, if you know what I mean. Like when we will be at a certain date within a week. But I want to highlight the entire row. Is that possible? If yes, please tell me how I should do it :)
Excellent video. I have a related question. How do I get the target cell background colour to change in Excel when using different search terms in the control f function? If it's possible please can you create a how to video? This would help me support colleagues with dyslexic/dyspraxic traits.
hi Kevin, thank you. i work on some large data sets and i am required to do a few things to save time. such as odd and even date coloring, difference of days between dates, and maybe even any simple short cuts . is there a video already that i can use?
Hi Kevin. Thanks for this, I am hoping you can help me with how to keep conditional formatting using power automate to generate multiple emails. I can use mail mege but it wipes the colour 'traffic light' warning system. Any thoughts?
What formula can be used in a sort of multiple choice type of scenario. (ie: if rain = rain coat. If above 80 degrees wear shorts. If 40 degrees wear jacket
This is really useful thank you! Can a whole row be coloured based on if a particular cell contains a specific word? So if a cell contains “Closed” the whole row does grey?
I loved your Conditional Farmating explanation. On the Restaurant Review, the Review column was not selected; How does Excel recognizes the written review arguments?
i have applied conditional formatting in due date column for auto colour change according to due date now I want to apply conditional formatting in numeric value column in Excel sheet , according to due date column colour i want that numeric value column should change auto colour in Excel sheet,so how to do this using conditional formatting? please guide me ASAP
What abt password protect a macro-enabled userform, (sheet or workbook) where user uses the userform without the password but will ask for password if user deviates from the userform? Or unhide other sheets?
Kavin, good day. I would like to ask how to extend the border of a certain table based on its content. i,e, for example, say it is a 5-column table, but now it has to extend to 10 column table with a border by conditional formatting. pls show an example. thanks
How to bold first 2 words in excel sheet. e.g: Procurement Cycle Time: Measures the time taken to complete the entire procurement process, from identifying a need to receiving the goods or services. I wanted to Bold text before Colon in large data at once. Please guide
⚡ If you want to test conditional formatting in Excel, you can access the spreadsheet that I used in the video here: 1drv.ms/x/s!AmxrofZZlZ-wg_9oT7UzsR6aXkkSDQ
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Hey Kevin. Cool video. How do you use conditional formatting for accounting. For example if I want to change the font color if the expense are greater than the revenue to red.
Thanks Dear
For those who do not know, this dude was literally the product manager for Microsoft Office 🙌
😮
Really?
Was?
@@Anonymous_Alien11 once a manager is always a manager 😏
Major reveal 😮
Another perfect video, with exactly the answer to the question, accurate to the title of the video, no delays, no distractions... GLORIOUS!!!
Thank you Kevin! Your videos are always to the point and easy to follow. :)
Youre just amazing and you saved my test tomorrow. ONGOD I LOVE YOU SO MUCH RN. BLESS YOU
I have a computer test too!
Appreciate your excel videos SO MUCH!!
So easy to follow! Great job Kevin!
The information of condutional formating which you gave to us is so limited and basic level. Its functionality is so huge. I’ m looking forward to advanced level of it 👍
Thank you
As somebody who was looking on guidance to more advanced topics, I should say that this is still invaluable to people who are not used to conditional formatting. I do wish the title could point out this is for basics, but it is still very useful.
Thanks Kevin - literally learned conditional formatting in a few minutes from this video - I am going to put it into practice from today. So useful. 😊
I like the multiple examples!
thank you for reminding me how it works!!!
You have excellent training and instructing skills!
I really enjoy your content!
Thank you, I love the data bars!
Could you do a tutorial on advanced excel functions?
really helpful, thank youuu
thank you so much! all your videos are a lifesaver!
thank you, can you please make a video on importing data short like this one?
Ans after 4 years of posting this video, I'm here to say thank you Kevin!
Amazing. Thanks
Thanks Kevin I can always count on your lessons.
You have helped me so much! anytime, i fear i do not anything in Excel or PowerBI, I always search for your videos! You are AMAZING! Keep going!
Thank you for getting me through my homework!
Great video and examples. Thank you!! :) Greetings from a Costa Rican singer!
Any excel tip or solution I am looking for - I just hope to see Kevin’s thumbnail..and then I know I am sorted.
You’re the best mate!
Thank you for the explanation
It was really useful
Amazing! So clear to follow.
This was very helpful! Thank you
Amazing. short and concise
Great Video. I could immediately do what I wanted to. Thanks !!!
Hey Kevin the video was amazing I m a student and had my computer practical’s tmr and the video really helped me nd can u please post videos on basic python programming it would be really great
Thank You!!!
Thanks kevin! you're a big help!
Thank you so much for this easy to understand tutorial!
I can only congratulate you and your tutorials they are so easy to understand for the older generation. I wonder if I could ask for a tutorial , I have lists of three column first column is a number, second column is a name, third column is either a Y or N ( yes or No ) Is there a way to total all of the number values with a Y's or N's in the list
Great sir , please teach me how to use if function with an example
Great!!!! Learning fast with your way of teaching. Thanks!!!
Thank you so much guy I completed my assignment very well method
This is powerful pls if u can do a video on advanced excel
Very useful. Thank you. I appreciate it
Thanks for the tips!
Thank you for this video.
Thank you. Very helpful video! :)
nice one. do a video of quick overview of using Excel for data analysis
Very helpful! Thank you!
Thank you. This was very helpful.
When the chef himself decides to serve the food....
Thanks Kevin, you always provide helpful tips and step by step instructions!
very useful video. thanks man!
Hi Kevin, I love your videos but am still learning on how to expand and use Excel in a bigger way. With that said, I am creating a simple project tracker spreadsheet for all my supervisors so I can keep track of project status and trying to use the strikethrough feature for completed items. I watched a video on how to do this but the video only explained how to do this for one row. I
would like to apply this to the entire worksheet without having to create a rule for every individual row( worksheet contains 250 rows :( Please HELP!!
Thnx the vedio was helpful
You made use of Interesting examples 😊. This was so easy to understand.
very helpful
Love the video!!!
Thank you! Very easy to follow:)
You are the best at teaching excel. Thank you! :)
Great video, thank you.
Very helpful thank you
Thanks Man 🥰
Hi Kevin. How do you format a list of numbers when compared to another list of numbers, ie compare each value on a line to one on the same line, without doing a separate format for each one?
Does anyone know the answer to this??
Awesome teacher
Thank you! 🫡
Great video!
Thank you so much!!!❤
I want to use Excel as a reminder, if you know what I mean. Like when we will be at a certain date within a week. But I want to highlight the entire row. Is that possible? If yes, please tell me how I should do it :)
Great vid bro !
Useful video, thanks for the help!
This video is useful.
Thanks
Thanks Kevin do something about in-depth sumifs
Excellent video. I have a related question.
How do I get the target cell background colour to change in Excel when using different search terms in the control f function?
If it's possible please can you create a how to video?
This would help me support colleagues with dyslexic/dyspraxic traits.
I’ve been looking for the same answer
SO NICE
It was amazing 😍 loved it 😍
very informative
hi Kevin, thank you. i work on some large data sets and i am required to do a few things to save time. such as odd and even date coloring, difference of days between dates, and maybe even any simple short cuts . is there a video already that i can use?
how to resolve error 400 in excel thank you for the answer
Dear Kevin, could you please make video of right steps to master Excel 😊😊😊
really wish u would've explained how to make the entire row after the column...
Thanks, I've found that conditional formatting has a lot of overhead on my high end computer when I copy all columns.
Hi Kevin. Thanks for this, I am hoping you can help me with how to keep conditional formatting using power automate to generate multiple emails. I can use mail mege but it wipes the colour 'traffic light' warning system. Any thoughts?
What formula can be used in a sort of multiple choice type of scenario. (ie: if rain = rain coat. If above 80 degrees wear shorts. If 40 degrees wear jacket
This is really useful thank you! Can a whole row be coloured based on
if a particular cell contains a specific word? So if a cell contains “Closed” the whole row does grey?
have you found this answer?
great i understood
Thank you
Hello Kelvin, Please can you do a video on Gantt chart?
I loved your Conditional Farmating explanation.
On the Restaurant Review, the Review column was not selected; How does Excel recognizes the written review arguments?
Is there a way we can make difference in cases while comparing two lists as well for example excel show the message "APPLE" and "apple" are not same?
Teach me, where we have many figure, how to Adjust All values below 30 in an excel to one uniform figure ie 50
Thank you!
i have applied conditional formatting in due date column for auto colour change according to due date now I want to apply conditional formatting in numeric value column in Excel sheet , according to due date column colour i want that numeric value column should change auto colour in Excel sheet,so how to do this using conditional formatting? please guide me ASAP
What abt password protect a macro-enabled userform, (sheet or workbook) where user uses the userform without the password but will ask for password if user deviates from the userform? Or unhide other sheets?
Is there a way to take this and make a list? Like in seprit scells giving me a list of all the dates that passed 6months.
Kavin, good day. I would like to ask how to extend the border of a certain table based on its content. i,e, for example, say it is a 5-column table, but now it has to extend to 10 column table with a border by conditional formatting. pls show an example. thanks
Great job explaining I understand perfectly do you have any presentations on Macro's
With conditional formatting how do I use it to identity cards with expiration dates
Thank youu
How to bold first 2 words in excel sheet.
e.g:
Procurement Cycle Time: Measures the time taken to complete the entire procurement process, from identifying a need to receiving the goods or services.
I wanted to Bold text before Colon in large data at once. Please guide
how to colour code different values from 1-1000 arbitrarily written in a column where maximum we can have 10 numbers in a colour.
Good
How to highlight one of three cells with lowest value that are not next to each other?