8 Expert Tricks for Conditional Formatting in Excel

[@andrewbouc6015]

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!

[@GameAGuy]

Hey Lelia is great too😊

[@yickwong3776]

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

[@nickwhite2996]

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

[@nsanerydah]

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

[@TeachExcel]

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

[@javedahmed8343]

So many points got cleared. A nice illustration

[@nairobi203]

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

[@sunglee2093]

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

[@Dharani_S]

Excellent conditional formatting!!

[@sereyvanny8123]

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.

[@mohammedziyadpa]

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

[@cocorajschaperderalderwere7784]

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.

[@lostinalgeria8492]

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 😞

[@TeachExcel]

What an awesome comment :)) I hope it goes well tomorrow!:)

[@praveenkumar_9143]

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

[@hmgkt]

Knowing these simple really help upgrade the use of excel.

[@jaxattax7357]

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

[@krishnaprakash3422]

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

[@Rais1959]

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

[@tanjinasultana7420]

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

[@MrAnas4]

Best video on conditional formatting

[@MammenJohn-f3s]

Great presentation and good contents to learn. Thank you !

[@barrygregg6058]

You do a fantastic job. Thank you.

[@nahlas.3836]

Awesome as usual!!!

[@jayantvedwan8157]

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

[@michaeloloishuro6915]

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

[@TeachExcel]

I'm really glad you like it! I was really worried about how long it was, but I'm glad you found it helpful :)

[@rajeevgosavi4514]

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

[@thebesttechnical3608]

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

[@satishkumardommeti8282]

Simple way to understand the power of conditional formatting

[@4-7th_CAV]

@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?

[@azizniazi2454]

Really informative video Special thanks

[@tomaspalacios2828]

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

[@FibFract]

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?

[@IsroNasa-r5m]

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

[@merajahmed3044]

Thank you for the tutorial

[@gayent01]

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.

[@jero007]

This is awesome, thank you!

[@karshawk]

who is here from jp morgan

[@sudarshandj145]

Did you cmplt the course?

[@karshawk]

@@sudarshandj145 yes but it's useless jonmorgan doesnt hire with this

[@xpon7833]

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

[@4-7th_CAV]

I do somewhat the same on one of my spreadsheets. I have a sheet to track recurring payments and their due date. I use the IF statement to populate the payment amount whenever I insert its payment date. I.E. if the recurring payment is $49.95 then when I insert the due date the payment amount will automatically be entered, if no date is entered the payment amount cell will remain blank. Then, I conditionally formatted the entire row to fill with a color which is dependent upon how many days it is from today to the due date. I.E. if the due date is 05-15-2020 and today is 05-01 then the cells have no fill color; if today is 05-09 the cells would fill with green; if today is 05-12 the cells fill with yellow; and if the due date is two days or less from today the cells will fill with red.

[@gonzinigonz]

Great video :)

[@clariefairy]

Thank you!

[@irfanmeghani]

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

[@TeachExcel]

Glad you like it!

[@slslrilil]

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

[@SolidSnake59]

Yes, you can .

[@GeorgeAJululian]

Many thanks very helpful

[@imranthamim3151]

22:43 sec how the 65 came in between that ??=MIN(Stock!D2:D8)

[@Rogue_Console]

Thank you for this.

[@sevenl.maxwell1686]

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

[@amygcowgill]

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?

[@anshul4370]

thanks bro

[@MegaTinni]

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.

[@aimanalalawneh5667]

Great job

[@unosec]

thank you for teaching

[@nimishpathela4630]

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

[@ravishingravi]

Thank you so much. I appreciate it.

[@tahirmanzoor1954]

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 ,

[@miamited69]

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

[@thriftymillionaire5968]

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?

[@regularbloke7410]

I can't paste formula in new formatting rule

[@mangalkayande8540]

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

[@dragoda]

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

[@TeachExcel]

Use a formula like this: =SUMPRODUCT(--(A1=$C$1:$C$3))>0 C contains the list and A1 is the cell to check. Get the formula working in Excel first before putting it into a custom conditional format rule. If you need more help you can upload a sample file and ask in our forum: www.teachexcel.com/talk/microsoft-office?src=yt

[@enricopunta2819]

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

[@HumanityMatters85]

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

[@inezgranada9954]

Is it possible to use conditional formatting: instead of

[@TeachExcel]

You can do that for sure. Just make a working formula in the spreadsheet and once that is good, pop it in a conditional formatting rule.

[@kirandeepchoudhry9232]

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

[@PawanKumar-nv8tb]

Nice video

[@TeachExcel]

Thank you Pawan! I'm glad you liked it :)

[@AlexandruCristianAdam]

I have a problem with my coloring based on value in the cell. So i have this Cell where is a total of Income and Outcome. Is a total for profit basicaly, so in the cell i have Income - Outcome. For easyness let's say i have a income of 100 but the outcome is 200, my cell is with red $-100, thats all good, but if i have the outcome 100 as the income, the cell is still red, showing $-0.00. Im trying to create a rule where the cell is green if the value is egual or greater than 0, but is not working, is still shows red cell $-0.00. I think is because the cell shows -0.00 instead of just 0.00 and i don't know how to fix that. If the Income is 100.01 for example, all is good, the cell changes to green $0.01, no more minus in front of it. Any tips on how can i make the cell show $0.00 instead of $-0.00 so that the cell can turn green? Thank you very much for your video.

[@MsAncele]

How protect it all from being change by users?

[@cescarrachi]

thank you!!

[@toxiqrox]

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

[@neishac.d7781]

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 ?

[@neishac.d7781]

However, there is no specific starting criteria. I would like to upload my data to excel and have it automatically flag rows that are duplicative based on the criteria mentioned above

[@TeachExcel]

Ask this in our forum and upload a sample file. Depending on implementation, this could be done many different ways. But, my instinct tells me that you'll want to use a macro. Forum: www.teachexcel.com/talk/microsoft-office?src=yt_reply

[@Fjuron]

Thanks!

[@pratikdandekar2654]

Thanks a lot

[@bahaaomar9927]

nice and cool, thanks

[@TeachExcel]

You're welcome!

[@leighboyd9854]

please add a table of contents

[@adityakumardhuria5280]

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.

[@Allinused]

=left(a1;3) =right(a1;3) might help? I dont know about the middle.

[@vivekk9232]

1:20

[@pankajgolakiya9666]

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

[@dereje71]

Please prepare free material for Ethiopian

[@fahadhameed-ne2dj]

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

[@dereje71]

10Q

[@hbtuoputhmebaitrrhho1842]

text