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!
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
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!!!!!
*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.
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
Wow been looking for this for a while, Thanks! Is there a way to find the unique values of the "department" list without having to make another copy of the list on a separate sheet?
Of course. Filtering the dataset works great. This exercise highlights the ability of making a choice from a dropdown that automatically highlights that selection.
Sir, please tell me. How is that applicable on multiple drop-downs column, linked to this whole data table or just a specific column only, from another sheet???
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
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
can you help me (great video by the way made my life a lot easier. I use excel to log jobs, dates, costs, and expenses in rows. When a job has been invoiced I mark the whole row with a green background. The problem i am having is that if I mark the last row off green, when I start to fill in details on the row below they automatically show with a green background, can you tell me why and how I can stop this from happening?
HELLO, DO YOU KNOW HOW TO USE CONDITIONAL FORMATING TO HIGHLIGH ROWS AND COLUMNS WHEN MULTIPLE CELLS ARE SELECTED. SUCH AS WHEN SELECTED FROM A3 TO D5 WITHIN A RANGE THE COLUMN FROM A TO D AND ROW FROM 3 TO 5 ARE HIGHLIGHTED. THIS NEEDS TO BE DYNAMIC TOO. THANKS IN ADVANCE.
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?
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
Is their a way i can use this with two different colours ? eg. i am making a "in storage" and "removed" list but want the removed to make the row red when changed in the list but the "in storage" to stay white.
But what if i want the Total values of the selected items to be store in a separate cell or report. Just highlighting is doing fine but for what end if i have to manually calculate of the highlighted row values.
sort the values by fill color(Not by values). all the highlighted(color filled) part will come at top. copy to other sheet and do required calculation there. Or, you can use filter and use subtotal function. else, you can convert the data into table, use filter option and tick total row in design tab. there can be a number of other ways to do it. you can definitely use pivot tables...
5 years later and I am so greatful for your video. Clear and easy explanations by far.
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
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.
It was exactly what I was looking for.. a lifesaver thanks so much for a complete tutorial!
thanks, it's 2023 and it works awesome... Life saver.
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
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
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!!!!!
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.
Wow!! Thank you for this amazing tutorial! My struggle was the formula in formatting... thank you!! 🏁👍🤗🎉
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
Thank you so much. Easy to follow and it works great. You saved me tons of time
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
A nice demonstration of conditional formatting. Thank 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
your tutorial is so much effective. I really enjoy it!
*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.
It was very helpful I love working with excel and this just made it easier and faster.
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
Great tutorial. Wouldnt filter do the same?
,
You are the man!!!!!!!! Thank you!
I'm loving this 👏👏👏👏👏
Thank you so muc.it's really helping me alot doing my jobs and easy to find my drob list data.
exactly what I was looking for! Thanks
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
Very nice. You have highlighted the rows with colour. In the same way, whether we can highlight the colours of particular column?
VERY GREAT TUTORIAL..!!!!!! PLEASE DO MORE TUTORIAL LIKE THIS.TQ.
Thanks alot...Sir...you make my day
Wow been looking for this for a while, Thanks! Is there a way to find the unique values of the "department" list without having to make another copy of the list on a separate sheet?
God bless you 🤗 ill be sure to share the knowledge.
Great Video ,Very Helpful
Why not just filter the columns?
Of course. Filtering the dataset works great. This exercise highlights the ability of making a choice from a dropdown that automatically highlights that selection.
Very useful video sir. What about auto populate the serial number so that no need to count the number of items manually
Many thanks for sharing. Excellent stuff.
Simple and informative way look to for desired data in a large table.
Thanks for sharing, its very helpful
Good Explanation - Thanks
awesome...thats what i was looking for
thank you it was very helpful
Easy but very useful, thank you very much!
Can you select multiple columns with the absolute feature in the same rule in the event I have staggered columns?@6:22 in video
so much informative I have learned using conditional formatting
Million thanks for your tutorial! Keep it up
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.
Thank you it was helpful for me
Thank You very much for the useful sharing, excellent !
It's super practical.. But who are those 59 who waste their time to put a dislike
Super useful, thanks a ton
Thank you so much sir this process will surely save my time....
I already got it correctly.. Thank you so much.
Very cool! Thanks
Wow! It’s really useful knowledge! Thanks for sharing 👌👍
Good explanation.
Sir, please tell me. How is that applicable on multiple drop-downs column, linked to this whole data table or just a specific column only, from another sheet???
Basic question: how did excel know to highlight the entire row that contained the matching department as opposed to just the matching cell?
Thanks a lot, this is super useful!
Very Helpful!
super useful ... Thanks
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
what formula do we put with the cell if we dont want it to hightlight empty cells in the table?
It's really good. But kindly tell me is there any way to copy all the highlighted rows at once???
Nice it's helpful for me I use your technique with my own condition some different.
How did you create the yellow orb on your cursor?
Very very Very. THANKS..........!
Really very Nice!!
thanks for below. Can you please give me an example where can it be used..?
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
can you help me (great video by the way made my life a lot easier. I use excel to log jobs, dates, costs, and expenses in rows. When a job has been invoiced I mark the whole row with a green background. The problem i am having is that if I mark the last row off green, when I start to fill in details on the row below they automatically show with a green background, can you tell me why and how I can stop this from happening?
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
Well explained. Thank you.
Sir
Is it possible to highlight a row in a different row color for each department
HELLO, DO YOU KNOW HOW TO USE CONDITIONAL FORMATING TO HIGHLIGH ROWS AND COLUMNS WHEN MULTIPLE CELLS ARE SELECTED. SUCH AS WHEN SELECTED FROM A3 TO D5 WITHIN A RANGE THE COLUMN FROM A TO D AND ROW FROM 3 TO 5 ARE HIGHLIGHTED. THIS NEEDS TO BE DYNAMIC TOO.
THANKS IN ADVANCE.
Thanks a lot for this tutorial.
Wow!! Thank you so much! This is really helpful!
Great job 👍👍👍
Easy & very usefull
Thank you this is very helpful. If you had a cheat sheet I would use it!
Thank you for share.
Pls explain in details why you used absolute referenced Column
Very clear, thank you!
Rwbcanvai vqjvajkakqkhw wyocqooqpqohcfwjvuvwngsnvsiqviqnhakqbiqncwjyqk vgaogce
Is it possible for different department, different color?
Better yet to use sort and unique so it will be a dynamic data validation and no need to update the validation list when there is a new department.
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!
How do we change the font colour as well in the highlighted rows as well
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?
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
How do you un-highlight the cells once you highlight them? Thank you!
Extend your drop down list to one black space. Then choose the blank space from the list
SUPER AWESOME
F4 IS NOTLOCKING-NOT WORKING FOR ME ANY OTHER KEY ..?
Just manually type it in.
You have to click F4 twice
*Thank you for the tutorial Excel brother and sister*
tricky perfect, worked like designing
If you a single column data transfer to another worksheet then if you delete those data that will not work the previous sheet
What to do if we need to add the values of the selected cells?
How to excel sheet multiple highlights row to insert row
Is their a way i can use this with two different colours ? eg. i am making a "in storage" and "removed" list but want the removed to make the row red when changed in the list but the "in storage" to stay white.
Yes, simply create a second dropdown list with a different fill color.
nice tip thanks for your efford
But what if i want the Total values of the selected items to be store in a separate cell or report. Just highlighting is doing fine but for what end if i have to manually calculate of the highlighted row values.
sort the values by fill color(Not by values). all the highlighted(color filled) part will come at top. copy to other sheet and do required calculation there.
Or, you can use filter and use subtotal function.
else, you can convert the data into table, use filter option and tick total row in design tab.
there can be a number of other ways to do it.
you can definitely use pivot tables...
Thank you so much for this. It has helped me a great deal
How if E column input number color is red then A column input number and B column input text color also will be red ?
How can I copy the highlighted data into another sheet??
Okay that was good but how about if I only wanted col(A:B &D:E) to be highlighted?