Excel Highlight rows and records
HTML-код
- Опубликовано: 5 авг 2024
- Use Excel to quickly identify specific records by highlighting them with a color. and choosing specific records from a list.
Link to Excel file for this exercise:
shiftkeycom.com/ExcelFileForH...
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!!!!!
Wow!! Thank you for this amazing tutorial! My struggle was the formula in formatting... 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
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!
A nice demonstration of conditional 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
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.
Thank you so muc.it's really helping me alot doing my jobs and easy to find my drob list data.
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
Simple and informative way look to for desired data in a large table.
Thank you so much. Easy to follow and it works great. You saved me tons of time
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
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, it's 2023 and it works awesome... Life saver.
It was exactly what I was looking for.. a lifesaver thanks so much for a complete tutorial!
Thank you so much for this. It has helped me a great deal
Million thanks for your tutorial! Keep it up
Wow!! Thank you so much! This is really helpful!
so much informative I have learned using conditional formatting
Wow! It’s really useful knowledge! Thanks for sharing 👌👍
Easy but very useful, thank you very much!
It was very helpful I love working with excel and this just made it easier and faster.
VERY GREAT TUTORIAL..!!!!!! PLEASE DO MORE TUTORIAL LIKE THIS.TQ.
Million thanks :) This is very helpful :)
Many thanks for sharing. Excellent stuff.
Thanks a lot for the tutorial.
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
exactly what I was looking for! Thanks
Thanks a lot for this tutorial.
Thank You very much for the useful sharing, excellent !
Thank you for the knowledge
Very clear, thank you!
Rwbcanvai vqjvajkakqkhw wyocqooqpqohcfwjvuvwngsnvsiqviqnhakqbiqncwjyqk vgaogce
Well explained. Thank you.
*Thank you for the tutorial Excel brother and sister*
Thank you this is very helpful. If you had a cheat sheet I would use it!
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
Nice it's helpful for me I use your technique with my own condition some different.
Thanks a lot, this is super useful!
Great job. Thanks.
You are the man!!!!!!!! Thank you!
Very much appreciated!
Oooo Really great effort thanks a lot it's so much helpful..:)
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 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
Thank you so much sir this process will surely save my time....
I already got it correctly.. Thank you so much.
Great tutorial. Wouldnt filter do the same?
,
Super useful, thanks a ton
Thanks alot...Sir...you make my day
Very useful sir, thank you
Great Video ,Very Helpful
Very nice. You have highlighted the rows with colour. In the same way, whether we can highlight the colours of particular column?
Thanks for sharing, its very helpful
God bless you 🤗 ill be sure to share the knowledge.
awesome...thats what i was looking for
Awesome Search Trick Sir .
How do we change the font colour as well in the highlighted rows as well
It was very much useful to me txs
Great job 👍👍👍
Bundle of Thank Sir
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
I'm loving this 👏👏👏👏👏
Good Explanation - Thanks
Very useful video sir. What about auto populate the serial number so that no need to count the number of items manually
What to do if we need to add the values of the selected cells?
Very Helpful!
When i go to creating a list and go to select the list on next sheet my excel doesnt allow me to do it. :(
It's super practical.. But who are those 59 who waste their time to put a dislike
Very cool! Thanks
Thank you it was helpful for me
useful information.....thanks
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!
thank you it was very helpful
tricky perfect, worked like designing
nice tip thanks for your efford
thanks for below. Can you please give me an example where can it be used..?
Excellent !
Thanks I love it
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?
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 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
Is there anyway that the only thing we see in the chart is the only items we searched?
Sir, I want to how can i arrange this color of rows (Matched)one by one top to bottom.
Thanks to helping
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!
Pls explain in details why you used absolute referenced Column
Hi
If i want to format a row with one column itself, then what to do
awesome!!
what formula do we put with the cell if we dont want it to hightlight empty cells in the table?
Really very Nice!!
If you a single column data transfer to another worksheet then if you delete those data that will not work the previous sheet
F4 IS NOTLOCKING-NOT WORKING FOR ME ANY OTHER KEY ..?
Just manually type it in.
You have to click F4 twice
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?
Good explanation.
Very very Very. THANKS..........!
super useful ... Thanks
Thanks a lot
It's really good. But kindly tell me is there any way to copy all the highlighted rows at once???