PERFECT, Exactly what I needed with less key strokes... The other way I was doing this was writing it into "1" cell then copying and pasting, etc.. etc... BLAH!!!! Your way was a time saver, thank you!!!!!
I literally spent half my work day trying to do this the other way that doesn't include the drop box - but THIS! With the drob box!? Amazing!! And it was soooo easy when i followed your clear directions - thank you!!! Now my spreadsheet is impressive!
Good Evening I was trying to do samething but fail now i saw this in youtube display so i watch this video n now my concept is clear Thanks dear respected sir Nice video Keep it up May God bless you with his rehmat Ameen 🏅for you
thanks you for giving a wonderful information but with me when i do that the above line been highlighted rather then the required line when i click any required department can any one help
everytime I want to share this with anyone, i already anticipate the way they will look at me as I am an excel nerd. No, I keep the magic of excel to myself
Great! What if you want to keep the duplicates on your master data set, but want to Highlight them when your department, item number, and total are the same between rows. So if when you upload the data, row 1 and 2 have the same department, item number, and total, those rows would highlight
I am trying to do some training for work on some spreadsheets. Does anyone know what was used to do this recording, especially that nice yellow mouse blob? Hopefully you can help! Thanks if you can!
Hello I am trying to use your tip from this video to help clean up a data file. I am struggling with creating the conditional format. When I select the item in the drop down list, excel is not highlighting the item selected. If you could help that would be greatly appreciative. Have a great day!
I have a large spreadsheet and would like to color each row based upon the value in column A on a second tab. For example: employees are grouped into teams with a representing color. On an accounts list that has the assigned employee in column a - I need for that row of data’s cells to match the team color. There are 3 teams so I would need it to loop back until it’s gone through all colors. Can someone please assist?
How do I highlight a range of cells according to the contents of another, in the same range, regardless of whether that cell contains a value OR text? i.e F252:I252 would turn yellow if ANY value OR text is placed in any one of these cells?
Great function. Can you add other columns that match? If I am looking in Dept for toys or electronics that match the region, item # and quantity in this examples. So Toys from SE matching item# 8001 with a quantity of 14 that all match. Since I won't know if any or which ones match can excel search all Depts and compare 3 or more columns? Thanks
*Once you do this, how can you tell Excel to GRAB THE DATA and move it to another sheet? Or maybe is there a copy function that will pick ONLY the highlighted cells?*
@@raccoon874 I see. You can use power query automations to extract specific data to a new table/sheet. The thing is the first time you set the algorithm it takes some time but after that if you have cleared all border cases then you have to refresh the queries and it works like a charm.
5 years later and I am so greatful for your video. Clear and easy explanations by far.
Thank you.
PERFECT, Exactly what I needed with less key strokes... The other way I was doing this was writing it into "1" cell then copying and pasting, etc.. etc... BLAH!!!! Your way was a time saver, thank you!!!!!
I literally spent half my work day trying to do this the other way that doesn't include the drop box - but THIS! With the drob box!? Amazing!! And it was soooo easy when i followed your clear directions - thank you!!! Now my spreadsheet is impressive!
BVs
Working on a Sudoku game in Excel and needed to learn how to highlight certain numbers that had already been played and this worked great. Thanks
Wow!! Thank you for this amazing tutorial! My struggle was the formula in formatting... thank you!! 🏁👍🤗🎉
We learn this in macros in Excel, but this is much easier, thank you for sharing. I tried the step by step on my mac and it was successful.
your tutorial is so much effective. I really enjoy it!
awesome your video really helped me out, and you really explain it patiently for those of us who just want an answer and nothing more!! thank you
A nice demonstration of conditional formatting. Thank you.
Good Evening
I was trying to do samething but fail now i saw this in youtube display so i watch this video n now my concept is clear
Thanks dear respected sir
Nice video
Keep it up
May God bless you with his rehmat
Ameen
🏅for you
Thank you for your tutorial!!. You explain extremely well from dropdown list to conditional formatting to an Entire Row. 👍👍👍😁😁😁😁
Kindly send this tutorial to me too
Thank you so much. Easy to follow and it works great. You saved me tons of time
Simple and informative way look to for desired data in a large table.
It was exactly what I was looking for.. a lifesaver thanks so much for a complete tutorial!
Thank you so muc.it's really helping me alot doing my jobs and easy to find my drob list data.
I learned so much! Beautiful and clear explanation. Thank you! I need other tutoring to build a budgeting in excel.
Fajcntwj agvsmbak w ia. Vsjhajiwiiwvuwihwjhsiwuwicvajciwbiwoowowok ahgwiuwoowowb wiw
Thank you so much for this. It has helped me a great deal
Wow! It’s really useful knowledge! Thanks for sharing 👌👍
Wow!! Thank you so much! This is really helpful!
Million thanks for your tutorial! Keep it up
It was very helpful I love working with excel and this just made it easier and faster.
so much informative I have learned using conditional formatting
Easy but very useful, thank you very much!
thanks you for giving a wonderful information but with me when i do that the above line been highlighted rather then the required line when i click any required department can any one help
Million thanks :) This is very helpful :)
exactly what I was looking for! Thanks
everytime I want to share this with anyone, i already anticipate the way they will look at me as I am an excel nerd. No, I keep the magic of excel to myself
Yes. Im in a house where they dont understand the capabilities of utilizing excel to your benefit.
VERY GREAT TUTORIAL..!!!!!! PLEASE DO MORE TUTORIAL LIKE THIS.TQ.
Many thanks for sharing. Excellent stuff.
When i go to creating a list and go to select the list on next sheet my excel doesnt allow me to do it. :(
thanks, it's 2023 and it works awesome... Life saver.
Thanks a lot for this tutorial.
Thanks a lot for the tutorial.
Thanks a lot, this is super useful!
Thank You very much for the useful sharing, excellent !
Thank you for the knowledge
*Thank you for the tutorial Excel brother and sister*
Nice it's helpful for me I use your technique with my own condition some different.
Well explained. Thank you.
Great tutorial. Wouldnt filter do the same?
,
You are the man!!!!!!!! Thank you!
Oooo Really great effort thanks a lot it's so much helpful..:)
I have an exam today and I'm sure he's gonna give us this, I'm thankful for your video i feel like i finally understand how to do it 🙏❤️
Gsn shczn xuwc w vzmvKVskvdkbsjoalhaonanzuiwcskwbsjhakvsnvhwivsuwbwuioqowbsh s.bakqb wjqbuwvwiwoqoqive
How do we change the font colour as well in the highlighted rows as well
Very clear, thank you!
Rwbcanvai vqjvajkakqkhw wyocqooqpqohcfwjvuvwngsnvsiqviqnhakqbiqncwjyqk vgaogce
Great! What if you want to keep the duplicates on your master data set, but want to Highlight them when your department, item number, and total are the same between rows. So if when you upload the data, row 1 and 2 have the same department, item number, and total, those rows would highlight
Very much appreciated!
can any one tell me that how can i copy only these highlighted line from the hole worksheet and past it to anther sheet
Great job. Thanks.
I'm loving this 👏👏👏👏👏
Thanks alot...Sir...you make my day
Sir, I want to how can i arrange this color of rows (Matched)one by one top to bottom.
Super useful, thanks a ton
Thank you this is very helpful. If you had a cheat sheet I would use it!
awesome...thats what i was looking for
Is there anyway that the only thing we see in the chart is the only items we searched?
I am trying to do some training for work on some spreadsheets. Does anyone know what was used to do this recording, especially that nice yellow mouse blob? Hopefully you can help! Thanks if you can!
God bless you 🤗 ill be sure to share the knowledge.
Hi
If i want to format a row with one column itself, then what to do
Thanks for sharing, its very helpful
What to do if we need to add the values of the selected cells?
Awesome Search Trick Sir .
Very useful sir, thank you
Hello I am trying to use your tip from this video to help clean up a data file. I am struggling with creating the conditional format. When I select the item in the drop down list, excel is not highlighting the item selected. If you could help that would be greatly appreciative. Have a great day!
Good Explanation - Thanks
Very nice. You have highlighted the rows with colour. In the same way, whether we can highlight the colours of particular column?
Great Video ,Very Helpful
I have a large spreadsheet and would like to color each row based upon the value in column A on a second tab. For example: employees are grouped into teams with a representing color. On an accounts list that has the assigned employee in column a - I need for that row of data’s cells to match the team color. There are 3 teams so I would need it to loop back until it’s gone through all colors. Can someone please assist?
Very cool! Thanks
It was very much useful to me txs
Thank you so much sir this process will surely save my time....
I already got it correctly.. Thank you so much.
thank you it was very helpful
Bundle of Thank Sir
what formula do we put with the cell if we dont want it to hightlight empty cells in the table?
very use full thank for video and best explanation ...
hi good but when u select green colour how to bring all green at one place colour in one click
thanks for below. Can you please give me an example where can it be used..?
How do I highlight a range of cells
according to the contents of another, in the same range, regardless of
whether that cell contains a value OR text?
i.e F252:I252 would turn yellow if ANY value
OR text is placed in any one of these cells?
tricky perfect, worked like designing
To select a specific data for multiple columns I would just need to set up the specific data set multiple times depending on my column headers right
Great job 👍👍👍
Thank you it was helpful for me
F4 IS NOTLOCKING-NOT WORKING FOR ME ANY OTHER KEY ..?
Just manually type it in.
You have to click F4 twice
Thanks I love it
Great function. Can you add other columns that match? If I am looking in Dept for toys or electronics that match the region, item # and quantity in this examples. So Toys from SE matching item# 8001 with a quantity of 14 that all match. Since I won't know if any or which ones match can excel search all Depts and compare 3 or more columns? Thanks
Very Helpful!
Thanks much, do you know if you still can borders after highlighting, like @7.25 the whole raw is green, and grey borders can't be seen.
ok i have a mac so F4 doesn't work! since f4 don't work im stuck!
Excellent !
nice tip thanks for your efford
super useful ... Thanks
Very useful video sir. What about auto populate the serial number so that no need to count the number of items manually
Pls explain in details why you used absolute referenced Column
Can you select multiple columns with the absolute feature in the same rule in the event I have staggered columns?@6:22 in video
awesome!!
Thanks to helping
*Once you do this, how can you tell Excel to GRAB THE DATA and move it to another sheet? Or maybe is there a copy function that will pick ONLY the highlighted cells?*
You should be able to filter by color and copy/paste filtered data into a new sheet
@@Chillman666 Yes I have found that out in the past year. I was thinking of a formula that does that extraction on its own.
@@raccoon874 I see. You can use power query automations to extract specific data to a new table/sheet. The thing is the first time you set the algorithm it takes some time but after that if you have cleared all border cases then you have to refresh the queries and it works like a charm.
useful information.....thanks
If you a single column data transfer to another worksheet then if you delete those data that will not work the previous sheet
Basic question: how did excel know to highlight the entire row that contained the matching department as opposed to just the matching cell?
SUPER AWESOME