⚡ 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: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
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.
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?
Thanks for you soo much 🌹 your videos help me allways I want to ask you if there is a way to colorize column in table if I change the value or any way to make the chang value Observable (I don't mean grater than or smaller than may be any change compared to another table) Sorry if my language is bad😅 thank you again 🌹
Guys i have question a1 celli, model number is : bh10274 a2 cell is item name : bh10274- Sport Short Question is ı have hundreds of it, how can i make it, we want: if item name contains model number in a1 or not thanks
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?
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, I was trying to record a video on conditional formatting but when I click the conditional formatting, I can see the expanded options but it is not appearing in the recorded video clip. Could you please advise?
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 :)
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 recently purchased MS 365 for my computer. I deleted Office 2010. When I try to use a shortcut to an Excel file I get "This action is only valid for for products that are currently installed". I cannot create a shortcut to my MS365 Excel files on my desktop. How can I do that?
In a list Lotto several games are played, such as Mega Lotto, Super Lotto, Grand Lotto, etc. They have respective winning prizes and the final prize with a winning combination of course the highest. So I would like to color rows under each specific game then color each game by rows differently and a darker color for the winning number combination prize and automatically filter all the current prizes maybe using a drop-down formula, whatever, but I don't know how to express it in a formula. Kindly show me how to use in version Windows 365. Thank you in advance!
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
I’m trying to Conditionally Format a column, where the first number is, we will say is a 100. the number below would be less, say 50, the cell would be RED because it’s lower. The number below would 50 wound be higher, say 60 and the cell color would be GREEN. So the column would continue in that manner. Just curious if there is a formula for something like that. I’ve been racking my brain trying to figure this out how to do this using NEW RULE and FORMAT ONLY CELLS THAT CONTAIN Thank you
Question - So in conditional formatting, for example, the data bars - the highest value is always the highest figure. Why is it set that way. If John has 95/100, his data bar shouldn't be full. Is there a way to set it without having to add a new cell with a value of "100" to it? Thank you
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
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.
How can I conditional format a whole workbook at once without VBA or Macro ? e.g. to color all cells in a workbook ( No a sheet at a time)n with the same cell value like Apple, Orange,....?
Hi Kevin. how can I hide rows based on a cell value specifically a drop down menu, using excel 2016. Using conditional formatting as an alternate to macros but my version does not have the "hide" option in the "font" tab. Thanks
How does excel determine good vs bad on words? The restaurant review column. Did the document author signify good vs bad vs neutral for each customer? Assigning a value for good vs bad vs neutral (e.g. +, -, 0)
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
Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make a monthly rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF). I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red. How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.
I have problems with copy/pasting using conditional formatting. It uses dollar signs when I create the ranges for my conditions. In doing so, it sets the conditions for the data I copied from to the the new location using the data from my copied source. The layout is the same, it just has different data. This situation forces me to individually set each condition. It is VERY time consuming. Is there a way to have it not use the dollar signs?????
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?
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.
Hello Kevin, I am trying to create a spreadsheet that I can use to include 4 columns of test result readings, that individually I would like to colour correctly between ranges of data but also using all 4 columns of data to create a cell that will colour code the quality of the total readings. That sounds confusing to me even. In short I have 4 different signal readings taken during testing, each of them have their own pass fail range but all used together create a total system quality, which I would like to show the corresponding column as colour from our pass fail range? I have no idea of where to start with this?
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
my issue is that we have a sheet we are constantly data to and it changes the conditional formatting rules every time we paste. for instance, if i have a cond. formatting rule set up for the entire A column, after pasteing in a new set up data, it resets to only apply to those cells we pasted into, rather than the whole column. anyway to lock the conditional formatting to the entire range rather than having it change every time we put in new data?
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
How to do conditional use formatting if for example a vendor has weekly limit of Invoice posting limit how to highlights on which week the limit got exceeded
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 can you use the ''equal to'' preset conditional formatting in excel to format multiple values in a range at once and not one at a time? Or if there is a better alternative to this conditional formatting, what is it, please?
Hi, I am trying to format dates in the future beyond next month. So I have one colour format for last month, one for this month and I need one to show dates beyond next month. I am using the following formula, but it just doesn't seem to work. =AND($E15>TODAY(),$E15>=(TODAY()>30)) I have also tried >60 days but still doesn't work. I would appreciate some advice.
I loved your Conditional Farmating explanation. On the Restaurant Review, the Review column was not selected; How does Excel recognizes the written review arguments?
⚡ 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: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
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 😮
Who are all come through Forage👋🏻
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. :)
Could you do a tutorial on advanced excel functions?
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!!
Appreciate your excel videos SO MUCH!!
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??
When the chef himself decides to serve the food....
Youre just amazing and you saved my test tomorrow. ONGOD I LOVE YOU SO MUCH RN. BLESS YOU
I have a computer test too!
So easy to follow! Great job Kevin!
Great sir , please teach me how to use if function with an example
Teach me, where we have many figure, how to Adjust All values below 30 in an excel to one uniform figure ie 50
Ans after 4 years of posting this video, I'm here to say thank you Kevin!
thank you for reminding me how it works!!!
plz help....
I am using this formula in conditional formatting in office 2019 version
=SUM(B$3:INDEX(B$3:B3,ROWS(B$3:B3)-1))
Thanks for you soo much 🌹
your videos help me allways
I want to ask you if there is a way to colorize column in table if I change the value or any way to make the chang value Observable (I don't mean
grater than or smaller than may be any change compared to another table)
Sorry if my language is bad😅
thank you again 🌹
Guys i have question
a1 celli, model number is : bh10274
a2 cell is item name : bh10274- Sport Short
Question is
ı have hundreds of it, how can i make it, we want: if item name contains model number in a1 or not
thanks
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?
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, I was trying to record a video on conditional formatting but when I click the conditional formatting, I can see the expanded options but it is not appearing in the recorded video clip. Could you please advise?
I could not follow this because you were going way too fast.
thank you, can you please make a video on importing data short like this 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 :)
how to colour code different values from 1-1000 arbitrarily written in a column where maximum we can have 10 numbers in a colour.
Hey Kevin, great videos and training. Which screen recording do you employ here, it is very clear chap
Chicken doesn't taste like anything. That's why cooks like it so much. They can flavor it any way they wish.
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?
really wish u would've explained how to make the entire row after the column...
Who's here from the forage (JP Morgan Chase Excel course)?
Unfortunately you speak so rapidly, it’s difficult to follow you.
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.
How do make column K turn blue when text in column X has specific text?
highlights conditioning stopped working after making a lot of rules
With conditional formatting how do I use it to identity cards with expiration dates
I recently purchased MS 365 for my computer. I deleted Office 2010. When I try to use a shortcut to an Excel file I get "This action is only valid for for products that are currently installed". I cannot create a shortcut to my MS365 Excel files on my desktop. How can I do that?
my problem is I don't know how to use formulas inside conditional formatting. I know the logic outside of that but its different inside there.
In a list Lotto several games are played, such as Mega Lotto, Super Lotto, Grand Lotto, etc. They have respective winning prizes and the final prize with a winning combination of course the highest. So I would like to color rows under each specific game then color each game by rows differently and a darker color for the winning number combination prize and automatically filter all the current prizes maybe using a drop-down formula, whatever, but I don't know how to express it in a formula. Kindly show me how to use in version Windows 365. Thank you in advance!
I really enjoy your content!
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
I’m trying to Conditionally Format a column, where the first number is, we will say is a 100. the number below would be less, say 50, the cell would be RED because it’s lower. The number below would 50 wound be higher, say 60 and the cell color would be GREEN. So the column would continue in that manner. Just curious if there is a formula for something like that. I’ve been racking my brain trying to figure this out how to do this using NEW RULE and FORMAT ONLY CELLS THAT CONTAIN
Thank you
I have a conditional formatting column for duplicates. However, I don't want to highlight the N/A just the phone Numbers that are duplicated. Please.
Hi sir I need to add one cell 1P1+3P2=4 how please guild me
You have excellent training and instructing skills!
Question - So in conditional formatting, for example, the data bars - the highest value is always the highest figure. Why is it set that way. If John has 95/100, his data bar shouldn't be full. Is there a way to set it without having to add a new cell with a value of "100" to it? Thank you
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
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
Get a better microphone man. Great info but the sound sucks.
How to highlight one of three cells with lowest value that are not next to each other?
How can I conditional format a whole workbook at once without VBA or Macro ? e.g. to color all cells in a workbook ( No a sheet at a time)n with the same cell value like Apple, Orange,....?
Hi Kevin. how can I hide rows based on a cell value specifically a drop down menu, using excel 2016. Using conditional formatting as an alternate to macros but my version does not have the "hide" option in the "font" tab. Thanks
How does excel determine good vs bad on words? The restaurant review column. Did the document author signify good vs bad vs neutral for each customer? Assigning a value for good vs bad vs neutral (e.g. +, -, 0)
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
Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make a monthly rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF).
I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red.
How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.
I have problems with copy/pasting using conditional formatting. It uses dollar signs when I create the ranges for my conditions. In doing so, it sets the conditions for the data I copied from to the the new location using the data from my copied source. The layout is the same, it just has different data. This situation forces me to individually set each condition. It is VERY time consuming. Is there a way to have it not use the dollar signs?????
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?
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.
I like the multiple examples!
Hello Kevin, I am trying to create a spreadsheet that I can use to include 4 columns of test result readings, that individually I would like to colour correctly between ranges of data but also using all 4 columns of data to create a cell that will colour code the quality of the total readings. That sounds confusing to me even. In short I have 4 different signal readings taken during testing, each of them have their own pass fail range but all used together create a total system quality, which I would like to show the corresponding column as colour from our pass fail range? I have no idea of where to start with this?
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 😊😊😊
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!
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
my issue is that we have a sheet we are constantly data to and it changes the conditional formatting rules every time we paste. for instance, if i have a cond. formatting rule set up for the entire A column, after pasteing in a new set up data, it resets to only apply to those cells we pasted into, rather than the whole column. anyway to lock the conditional formatting to the entire range rather than having it change every time we put in new data?
How to affect a different cell from another cell's data?
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
How to do conditional use formatting if for example a vendor has weekly limit of Invoice posting limit how to highlights on which week the limit got exceeded
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
Thank you. Very helpful video! :)
formatting colour of date it is not happening
Thank you sir. Pls sir I want to send an excel workbook to someone in an editable mode but I don't want someone else to copy it from him
Thank you so much guy I completed my assignment very well method
Hi
How to copy highlighted cells in a column?? Can u please tell me is there any easy way to do that
How can you use the ''equal to'' preset conditional formatting in excel to format multiple values in a range at once and not one at a time? Or if there is a better alternative to this conditional formatting, what is it, please?
Good
you talk too much and is unnecessary
Hi,
I am trying to format dates in the future beyond next month. So I have one colour format for last month, one for this month and I need one to show dates beyond next month. I am using the following formula, but it just doesn't seem to work.
=AND($E15>TODAY(),$E15>=(TODAY()>30))
I have also tried >60 days but still doesn't work.
I would appreciate some advice.
how can we highlight only certain text
I loved your Conditional Farmating explanation.
On the Restaurant Review, the Review column was not selected; How does Excel recognizes the written review arguments?
nice one. do a video of quick overview of using Excel for data analysis
Thnx the vedio was helpful
How do you conditional format for text in multiple columns?
Question how come when I use icons and try to transfer to a PowerPoint the icons won’t show as icons?
Wamtto learn Weeknum function
thank you so much! all your videos are a lifesaver!
Great video and examples. Thank you!! :) Greetings from a Costa Rican singer!
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?
Thank you for the explanation
It was really useful
so no way to sort in not alphabetical order
Oh god please get a better mic
How do I create a rule to go across multiple spreadsheets?
thanks I get in just one minute and dont watch whole video
This is powerful pls if u can do a video on advanced excel
Hello Kelvin, Please can you do a video on Gantt chart?
very useful video. thanks man!
Great vid! But what do you play on Steam?
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!
tadlonga mag todlo beh
Thank you so many much