I RARELY comment on youtube content. Your presentation was concise, complete, informative and, most importantly, gave me exactly the answer I needed. Keep up the good work.
@roddh8852
3 жыл бұрын
Agreed. Best one yet.
@mrryanclewis
2 жыл бұрын
@@roddh8852 Agreed best excel tips video ive come across. No fluff, well prepared, good work!.
@tesshensch
3 ай бұрын
I am impressed by all your presentations. You jump right into the subject matter and give more time for detailed and concise explanations, making it easy for me to follow along. I have learned a lot from your videos (from the simple to the complex power queries) and always recommend your tutorials to people who use or trying to learn Excel. Thank you for sharing your knowledge and expertise. Looking forward to more tutorials!
@BearBearCammy
4 жыл бұрын
Oh Gosh! My 6 months headache has been solved! Thank you so much for your easy tutorial! Appreciate that!
@aayushsinha3436
4 жыл бұрын
Please check this for excel learning kzitem.info/news/bejne/ln9my4yrimiFZYo
@SPmorality
3 жыл бұрын
you saved me a couple of days of work! You're a legend, sir
@willow1273
3 жыл бұрын
Thank you so much for this info. You are very detailed and made very easier. Keep up the great work and thank you once again!
@janetgannon7729
2 жыл бұрын
Hi Sumit. Thank you so very much for your video. I was able to pause and try it as you clearly explained and did it, and it has provided me with the exact solution that I have been looking for for ages. Looking forward to hearing more of your tips and tricks.
@nickkapatais
2 жыл бұрын
Excellent, concise and to the the point. Thank you.
@MarthaBHamilton
3 жыл бұрын
Wow..this was great!! thank you! You were so good at explaining what you were doing and how to do it! and gave great "similar" but different examples!! You just made my life so much easier! Thank you - can't wait to try the new options you showed!
@djmachow-davis9904
3 жыл бұрын
SUPER HELPFUL THANK YOU!
@AnhHoang-k3v4t
10 ай бұрын
Thank you for the video, very clear instruction!
@298Shahbaz
3 жыл бұрын
VERY GOOD AND TO THE POINT VIDEO. GOD BLESS YOU. KEEP UP THE GREAT WORK
@chandrasekharm5584
Жыл бұрын
Really help full and good explanation
@trumpexcel
Жыл бұрын
Glad you found it helpful 🙂
@ckaledin
4 жыл бұрын
Thank you for this! Really clear and to the point
@abigailotero7414
2 жыл бұрын
This was a fantastic resource! Thank you.
@suryakantthakur1879
4 жыл бұрын
Very informative and helpful. Thank you very much.
@Sossingro
3 жыл бұрын
Really good, thanks for this! I only really needed thestarting info to double check something so didn't watch until the end. I scrubbed through the video just in case, but my Excel had the option to duplicate the rule so it was a bit faster to duplicate and change the search query to something else. Really appreciate the great tutorial though!
@PrabodhMishra
4 жыл бұрын
It is useful and well explained. Subscribed as well. Thanks
@Simonkenteriksson
Ай бұрын
Great video :) Thank you!
@kuch_gungunaye
3 жыл бұрын
Nice video with lots of important information, thanks.
@AgapeoNtsinzi
2 жыл бұрын
Exactly what I needed. Thank you
@khryl9347
Жыл бұрын
how would I go about the following: highlight all rows that have the same value as the currently selected row
@pankajdubla4061
3 жыл бұрын
Dear Sir, Video is very good but this is not properly zoom and view quality . Thanks
@menachemspielman145
3 жыл бұрын
Thank you! This is THE ONLY video that I've found after looking into this for like an hour that actually gave me what I needed, and even better, in an easy to understand way!
@krishnamanjunatha6183
10 ай бұрын
col D having either A or B. if i select either the value A or B, that entire row shud b highlighted instead of entire range wherever the value A exists. colour shud b change for row A & row B
@sanketnarkhede2585
3 жыл бұрын
If I have to change the color for only row from where the value is changed , and changed again if value changed , what should i have to write
@MT-rg4dm
Жыл бұрын
Can you add more absolute columns attached to C2?@1:31 In video
@wmnicholls4851
5 жыл бұрын
I like how you explain it. Thanks.
@krajanch
2 жыл бұрын
Very informative and useful. Justone question. If I want to highlight the rows containing only the four digit year(eg there is a total appearing at the end of each year and I want to highlight this row)How should I constitute the formula. Thanks
@bargoti9
Жыл бұрын
did you find the answer
@SusmitaMelodies
3 жыл бұрын
Very helpful 👍
@pstopscars1602
Жыл бұрын
I had one interview where ask me same conditional formatting question, which is resolve by you sir, Thank you, also 2 sum based on formula not resolve could you help it.
@johnbrown7998
Жыл бұрын
Well presented thanks
@magibis7519
Жыл бұрын
Video is very helpful. I have one Question. If system time is less than 2 hours then entire rows should be Orange. Let's understand by the example...i have cell A1 has 12-15-2022 02:14 PM and i want to make it Orange color for entire row automatically if system time is less than 2 hours (12-15-2022 12:00 PM). How to do this.
@KobiLDN
Жыл бұрын
great tutorial
@graysonmiller5869
2 жыл бұрын
please help, when i do this for some reason it will highlight data that does not fall under the conditions
@beeanca411
5 жыл бұрын
This is super helpful! Thanks so much!!!
@Non-disjunction
3 жыл бұрын
How do I select the rows so I can copy them to a new sheet, instead of highlighting them?
@marcymarc1981
3 жыл бұрын
Thanks so much, worked like a charm, now I've got a colour-coded interactive to do list :) (now I just need to get off KZitem and do my actual job haha)
@MarthaBHamilton
3 жыл бұрын
haha.. me too!!
@WittayaThanasongtrakul
Жыл бұрын
good explantion thanks
@dancodrut
3 жыл бұрын
very good! useful
@nataliapolyzou8150
3 жыл бұрын
Very helpful video!!!!
@mstheboss9432
2 жыл бұрын
I have applied this formula but all row getting highlighted please help me.
@rahuljadav6298
Жыл бұрын
how to change color of columns based on above cell value greater than or less than
@khadijajaafar
4 жыл бұрын
based on text is not working for me
@jamoyjr
3 жыл бұрын
Thank you so much!!!!
@areebanwar2368
2 жыл бұрын
How to highlight whole row with textlength by one celll??????
@zolaskweyiya1902
2 жыл бұрын
Dude I love you
@keithward7725
5 жыл бұрын
Well done! Thank you!
@ameliamann5267
4 жыл бұрын
Hi, I have learn a lot watching these, however I'd like to be able to change a call color if multiple cells have information in them. for example column A Row 5 cell turns green if all cells from column B Row 5 to Column N has information in them. Could be a yes, no, date, phone number text etc.... But each of those cells must contain some sort of data. When they do A5 turns GREEN and if they don't A5 stays RED. I can't find how to do this anywhere.
@worldisamazing6739
2 жыл бұрын
Thanks a lot bro.....
@wreilly09
2 жыл бұрын
Thank you!!!
@kashmoney1
3 жыл бұрын
love it!
@forsakenfalcon
Жыл бұрын
Thanks
@Dhananjay2011
5 жыл бұрын
Great Video
@codewithdev1476
3 жыл бұрын
thanks bro
@harsinchh4342
Жыл бұрын
How to highlight the column C, range - on the based on max value of column A to min value of column B. A B C 50 60 1000 30 20 2000 [90] 50 (3000) 30 40 (1000) 20 [10] (5000) 40 80 80000 30 20 10000
@sarkarji960
4 жыл бұрын
very good
@Ozibar
5 жыл бұрын
Teşekkürler.
@bevhales6951
Жыл бұрын
I've watched a number of videos to find out this information, while it worked on the screen for the presenter, there was something missing, so I didn't get their results - then I found your video. It worked first time and gives me exactly what I was looking for. Now I can move my workload forward and hopefully you'll also have answers to other questions I come across. Thanks for your organised, logical and clear explanations. I don't know your name but I'm extremely grateful for your help, thank you. 😊
@czens2002
3 жыл бұрын
How would you write it so if the cell contains the text in the cell. IE higlight if the cell has Hot in it [unable to find HOT] The cell would have multiple words in it but highlight the row if one of the words is hot.
@House0399
4 жыл бұрын
Nice video ... it helped me figure out I was using to broad of a range on my formula. I'm getting the results I need with your very simple formula. Thank you for making something complex, easy to understand.
@paavosederholm5136
Жыл бұрын
This was great, and well explained! Only made it to 3:09 and already found what I needed :)
@davidwill5347
4 жыл бұрын
Thank you from Tokyo. Your explanation solved all my problems!
@trumpexcel
4 жыл бұрын
Thanks for commenting David... Glad it helped!
@NigelStock-coach
3 жыл бұрын
Excellent tutorial. Concise, very informative and just the right tempo.
@ShovonMallick41
2 жыл бұрын
[Product ID, Name, Category, Specification, Quantity, Minimum_Quantity] those are my columns, I want to highlight all rows(Which are dynamic) where Quantity is less than Minimum_Quantity, How to do that?
@audiomemento
3 жыл бұрын
Excellent! thanks!
@ThomasPowersrockslide
4 жыл бұрын
That was very helpful, just what I needed, and I was able to figure out how to do this in Google Sheets from here. I've been trying to figure this one out for a while, thanks very much.
@zeerakkhan6980
3 жыл бұрын
PLEASE HELP!! I want to highlight the Rows with the same color however there is a condition that: Highlight a Row when in the column "A" word COMPUTER appears. Highlight a Row when in the column "A" word LAPTOP appears. Highlight a Row when in the column "A" word TELEVISION appears. Highlight a Row when in the column "A" word IRON appears. I want to highlight all those ROWS with the same color whenever these words came in the column. I hope you understands my question and will reply the query. Thank You.
@NealHartsChannel
Ай бұрын
How do you do this so that the rule sticks in a pivot table? I've applied this and every time the pivot table opens up or refreshes the rule gets changed.
@alexandrab.910
Жыл бұрын
Thanks a for this tuto! It was very useful and well explained 🙂
@muhammadashrafkhan6303
4 ай бұрын
Question about (Highlight rows based on the text value) , If i want Bob and MarK both column highlight with one formula what can i do?
@karenbalmbro3159
2 ай бұрын
Please can you advise what the formula would be if I wanted a range of cells to be looked at and if they contain a word, then the row colour is changed is that possible please, thank you
@thedylanshow1
7 ай бұрын
Brilliant! I found the DATE tip the best one since I was trying to have my team's completed cell that had a date in it gray out that row. I just made the date a long time ago! Thank you!
@karthikravoori
10 ай бұрын
Hello Sumit, I am looking for highlighting each row based on the status of each row for a dashboard experience
@rahulsemwal9879
2 жыл бұрын
is we can also use =countblank($A2:$F2) ?? is this Right , one more options for highlight Blank??
@sivanithrankr9076
10 ай бұрын
Great Video well explained Thank You So Much......
@Copan3000
3 жыл бұрын
How is it the first thing he went over is exactly what i was trying to do but was failing because i forgot the double "
@ajeetthetraveler8154
3 жыл бұрын
Why sometimes I am not getting results?? I can't determine my blank cells
@donzelpaul1434
2 жыл бұрын
is it possible to do this with a drop-down menu but it changes colour when text is changed?
@jasonsupreme1980
2 жыл бұрын
Hi thanks for the tutorial but i'm trying to find a away to highlight a "Row" that contains one or more string of text in a single cell, for example if we look at your table shown in the video you have the word "White Board" in a single cell, how can I highlight all the "Rows" that contain the word "White" in it?
@bananasdoingthetwist
4 жыл бұрын
Hi Sumit, great video, I wonder if you can help? I'm not sure what I'm doing wrong but when I follow the instructions, instead of the row that contains the text, it highlights the row above.
@bananasdoingthetwist
4 жыл бұрын
Actually nevermind, I've figured it out! :)
@swetharamesh31
4 жыл бұрын
How you figured out please help
@suryakantthakur1879
4 жыл бұрын
@@swetharamesh31 Do not select column heading, chose only data as range.
@negocios0rsk
3 ай бұрын
Thanks, Nice clear instructions!
@OzduSoleilDATA
4 жыл бұрын
VERY HELPFUL!!!
@trumpexcel
4 жыл бұрын
Glad you found it useful Oz :)
@kamrulzoha9223
2 жыл бұрын
I AM YOUR FOLLOWER SINCE 5 YEARS AND NOW I SEEN YOUR FACE
@GibsonGuitarPlayer27
2 жыл бұрын
Excellent Video! Thank you!!
@AK-td9zn
3 жыл бұрын
Thanks very much, really helpful
@harshavardhan-nl4ms
2 жыл бұрын
How to select all highlighted rows??
@jaishrisaxena1083
4 жыл бұрын
very nicely explained! by providing practice sheet , u made it soo easy!
@aayushsinha3436
4 жыл бұрын
Please subscribe for excel formula
@aayushsinha3436
4 жыл бұрын
kzitem.info/news/bejne/ln9my4yrimiFZYo
@AbdurRahim-ot5gp
3 жыл бұрын
Very bad video because not clear.
@skillsforchildren
2 жыл бұрын
Thank you very much!
@Anikvikram
2 жыл бұрын
Thank you,great 😊
@vicvic553
3 жыл бұрын
Hi, I have got a problem. I want to do a conditional formatting with a formula: =$E11=$F$11 and in the cell F11 I would like to write any kind of value in which I am interested (by default I wrote 1500). I am working on my own data and the E column contains salary. However, this formula doesn't work for me at all. Could you help me, please? (I don't have a list in F11, I want to write any possible value there.) I also have a question, does conditional formatting only formats rows? Is there a way to have a conditional formatting for columns?
@rommel3942
3 ай бұрын
THANK YOU
@sharathpuni3905
4 жыл бұрын
Hi sir if value is 0 what to do
@robertdima7282
3 жыл бұрын
So, I've been trying to make CF work for about an hour with my spreadsheet and sometimes Excel 2010 just changes the formula you make for no obvious reason, and sometimes it just doesn't apply it right. For anyone out there who has this same issue, CF seems to work if you apply your formula for one row in the range of cells and then copy and paste the formatting to the rest of the datasheet. To copy and paste formatting: Select the cell or cells whose format you wish to copy. Press Ctrl+C or press Ctrl+Insert. ... Select the cell or cell range into which you want the formats pasted. Choose Paste Special from the Edit menu. ... Choose the Formats radio button. Click on OK.
@amiraboodi2075
2 жыл бұрын
You are awesome.😉
@Phyoomz
5 жыл бұрын
Who could've disliked this video? DAMN LIBERALS! lol
@willierants5880
2 жыл бұрын
Nicely done! I was going to write a long comment, but I'm not the first to comment on how well presented this was. So DITTO.
@manjitsingh-si8ir
4 жыл бұрын
May i know the way in excel to fix a cell color in live trading market. example in stock market if my target share price hit then color will change and it should constant not changeable. suppose if i said if price>100 then color change green. if market goes 102 it green but it still green if market comes back after few mins at same 100 rs price.
@dbharadwa
2 жыл бұрын
Been looking for someone to explain this properly and this man has done within the first few minutes of his video without any filler. So good I am gonna subscribe.
Пікірлер: 136