thank you so much for this! definitely need this as a refresher n your voice is great for teaching this, very calm n articulate too :)

You do a much better job of explaining this than others. Thanks.

I have tried different channels and your tutorials are the best. THE BEST. Much appreciated.

Fantastic tutorial !! Very precise and accurate delivery. god bless for your act of kindness. Thank you very much.

Good John, very impressive. Made complex things look very simple. Great!

@TeachExcel, Thanks for your clear and understandable explanation of conditional formatting. I have used this type of formatting on several different spreadsheets and in varying ways. One thing I have a hard time understanding is when you use multiple formats on the same sheet and a given format essentially cancels out the other formats, i.e. if you have 6 formats and only one of the 6 is "true" and all of the remaining formats are "false", what is the purpose of the "Stop If True" option check-box on the right side of the dialog box, an how is it used?

Amazing video and got to know more about conditional formatting using dynamic formulas!! and got an opportunity to hands-on practice along!!😍😍

Great and easy way of explaining the topic, thank you very much.

You solved my problem and I didn't even realize that your example worked. Great job! Thanks a bunch.

This is awesome, thank you!

I don't even know why I waste time on other Excel youtube videos. Your content is in a rare group of simply explained but not at all painfully obvious. Perfect for an intermediate user like me!

Many thanks, your instructions taught me exactly what I have been searching for

Amazing excel video, I could not figure out what is was doing wrong in my formula’s. Only to watch this video and it being explained perfectly. Thanks you, bravo.

Thank you so much!!! I had to do this today, and I wasn't able to get it to work right, and your video helped me fix my issue.

Very simplified demonstration on a hard conditional formatting topic. Thanks.

Really informative video Special thanks

Explained it SO Good. Completely Got it. Keep it UP 👍

Applying the conditional format to other sheets is crazy…. Thank you very much ❤

Thanks. It's very informative. Looking forward to your next tutorial.

By far the best explanation I found so far...

Thank you so much. I appreciate it.

Excellent conditional formatting!!

thank you for your tutorial this was really helpful. I am trying to find a way to highlight a cell on one tab and have the same information on a master tab highlight. For example I have people grouped by department on separate TABS and then all the departments list of people on the master tab. I would like to highlight the person on their department tab when I receive a reply and then have that match the name on the master tab and highlight it also.

wow.. that's amazing tips and tricks.. thank you!

thank you for teaching

Best video on conditional formatting

Thank you for the tutorial

It's not tedious at all !!! I find this sooo satisfying ❤️❤️ my only regret is that I have to wait till tomorrow to be able to apply this, cause I don't have a computer at home 😞

Great presentation and good contents to learn. Thank you !

The concept was super useful. Is it possible to use “Name Ranges” within formula in Conditional Formatting

This was pretty simplified and exactly the refresher I needed! Thanks! 🙌🏾

Simple way to understand the power of conditional formatting

Many thanks very helpful

Very nicely explained. But it did not work for me when I was trying to apply to one column based on whether the other col has value

Awesome as usual!!!

i need help comparing two cells with a high and low value, one of the cells is blue. Return 1 if the lowest value is blue color or return zero if the higher value is blue color. how do i perform this task in excel?

Hi, I have a rather difficult question: I got a file Excel with activation macro. I use many conditional formatting and I wish that the interval of application would remain unchanged. I think that the problem are the macros but I obtain no effect registering a macro and setting the conditional formatting. Do you have you any ideas? Thanks

Knowing these simple really help upgrade the use of excel.

Thanks for laying out conditional formating. Plz increase the audio from your side , for us to hear you clearly- Thank you!

Thanks!

Thanks a lot

Thank you for this.

thank you!!

Hi, I have 11 sheets in a workbook and every week I add a new row of data to each sheet. I copy the last row and paste above since it has formulas then add the new weeks data. I have conditional formatting by color scale for each column, but the conditional formatting does not update to include the new row in comparison to all data in the column. So, I then have to manually update the conditional format rule to include the new row. Is this possible to automate? Any suggestions?

Hi, I want to highlight cells in two different columns when there total gets equal to eachother like ist column is not next to each other they are separated by three columns.I hope you understand my query. Plz reply when u get time

thanks. you gave me the short version. lol... i always use the "If" and put lots of "IFs" to acomodate my need

Great job

I need advise on a custom sheet. We have a bunch of options laid out with developer check boxes next to them. If a tech is offering that benefit, they select the tab which changes the cell value to TRUE. Right now I have it so that the whole sheet is a light grey font, with the idea that if they change the text box to true, the font color (not row) will change to the auto black color and become bold for the manager to look for. I cannot get this to work for conditional formatting. Is there a work around?

nice and cool, thanks

Great video :)

I fuckin loved it , i'd seen Lodda clips but this 1izzzz. The best

So much to learn, I need to find a much more simple instruction, I am a beginner

thanks bro

been all morning banging my head on the wall just to find out here why there are "$" signs, thank u!

can someone please tell me how does he copy the code from the first cell till the end of the data , i used double click but that copies the formula till the end cell of the sheet

How to highlight one of three cells with lowest value that are not next to each other?

How protect it all from being change by users?

MY FULL EXCEL VBA COURSE (Beginner to Expert) [80% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_lIqifDg2xfE 200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

Hello, how can I color several random numbers from a series, like, i want all numbers 7 48 25 32 17 to be red. and then again, other numbers in other colors, blue for numbers 4,16,19 without having the need to set a new rule for each number, like 7 red, go again and set rule for 48, etc. Thx

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))

You didn't explain how the hierarchy works between multiple conditional formatting rules for the same cell. The 'stop if true' checkbox I see there. Thanks.

HI. hope you are doing great... I just want to know how to manage formula for dates in cell. i have two cell, one is plan and one is actual. How i determine that if the plan date is 24-08-2023, & actual date is 25-08-2023 , so the delay of 1day is highlighted automatically how is possible ,

Is it possible to use conditional formatting: instead of

please add a table of contents

Nice video

i have a series of number in a cell let say 1,2,3,4,5,6,7,8,9,10,11,12 . now i want to separate them by giving certain values like if there are 1,6,10 these three should come out separately in different cell , 2,7,11 these three come together out in different cell , and 5,9 comes in different cell, similarly 3,4 separately and 8,12 separately. i mean i want a output like this 1,6, 10 2,7,11 5,9 3,4 8,12 . please help how to do it with a formula.

Hi ! I am looking to add a formula in my excel spreadsheet to flag/ highlight duplicate data; however, the duplicate data has a criteria (e.g, flag all rows where the name, date, and number are the same as another row) is this possible ?

I can't paste formula in new formatting rule

Please prepare free material for Ethiopian

1:20

How to formulate present perfect sentences to conditional sentences? For example.... Situation one ... (1)I have just eaten so, I can't go out with you for dinner....how to formulate this present perfect sentense(I have just eaten) If I did not eat, I would go out with you for dinner. Or If I had not eaten, I would go out with you for dinner. Any teacher has never discribed about how to convert conditional from present perfect....they always discuss about past situation but what about recent past which has connection with present....can we use second conditional or we have to use past perfect in those types of situations....please guide about recent past which has connection with present.....second situation (2)He has killed his wife so police will arrest him. If he did not kill(or had not killed)his wife, police would not arrest him. Situation three... (3)He has killed his wife so Police has arrested him. If did not kill( or had not killed) his wife, Police would not have arrested him. As every one says Second conditional is used for 'present' and 'future'.....dose the 'present' mean 'present simple' or' present perfect'? Third conditional used for past tense.does it mean 'past simple' and 'resent past(present perfect)?... Please guide me I am very eager to know your answer..

10Q

SO MUC COMPLICATED DINT UNDERSTAND ANYTHING AFTER 5MINS ALL THIS HUGE LONG FORMULAS

text