Excel Highlight rows and records

Comments(47)

  1. Msh Jahid says:

    Thank you.. 😍😍

  2. Abdul washey says:

    Thank you for the tutorial Excel brother and sister

  3. Jeremy Strickling says:

    Very much appreciated!

  4. mariam qaiser says:

    It's really good. But kindly tell me is there any way to copy all the highlighted rows at once???

  5. Kawsar Ahmed says:

    Wow! It’s really useful knowledge! Thanks for sharing 👌👍

  6. Md Farook Hossain says:

    If you a single column data transfer to another worksheet then if you delete those data that will not work the previous sheet

  7. Baliong Erewiong says:

    How do we change the font colour as well in the highlighted rows as well

  8. Mavrik440 says:

    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.

  9. Sankareswaran ramalingam madurai says:

    Super sir

  10. Mahaboob Hossain says:

    TNX

  11. Maria Friend says:

    Why not just filter the columns?

  12. Miranda Humphrey says:

    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!

  13. Ajay Mukhija says:

    When i go to creating a list and go to select the list on next sheet my excel doesnt allow me to do it. 🙁

  14. Md Farook Hossain says:

    I DID NOT GET THAT YOU COPY ONE COLUMN FROM the FIRST SHEET TO the SECOND SHEET IF I DELETE ALL DATA IN the SECOND SHEET THEN DROP DOWN LIST IN FIRST SHEET WILL NOT WORK

  15. Md Farook Hossain says:

    if i delete sheet 2 data then sheet 1 menu bar does not work

  16. Tabish Hanif says:

    Sir,
    If I have similar sheet and want to highlight an entire row by typing specific words and each word has different colour… So how can I do this ?
    Kindly mail me at : tabish.hi5@gmail.com

  17. aziz niazi says:

    Respected Sir ! kindly send me work sheet for practice .
    azizniazi727@gmail.com

  18. iamAevolet says:

    thank you

  19. I love puppies says:

    Good job 😀

  20. Ali Basil says:

    thanks.

  21. Mahadev Gujre Salbardi says:

    very useful

  22. Jani Dost says:

    Thank you for the knowledge

  23. Akhil Babu says:

    useful information…..thanks

  24. alice p says:

    teach this on a mac computer or apple! please

  25. alice p says:

    ok i have a mac so F4 doesn't work! since f4 don't work im stuck!

  26. Nadeesha Chandrasekara says:

    It was very much useful to me txs

  27. Thiru Malai says:

    Very useful sir, thank you

  28. Secret Intelligence says:

    VERY GREAT TUTORIAL..!!!!!! PLEASE DO MORE TUTORIAL LIKE THIS.TQ.

  29. suhail khan says:

    Great job 👍👍👍

  30. erin davitt says:

    Great tutorial. Wouldnt filter do the same?
    ,

  31. mahamohan1 says:

    Simple and informative way look to for desired data in a large table.

  32. The Legend says:

    Thanks a lot for the tutorial.

  33. praveena buddha says:

    so much informative I have learned using conditional formatting

  34. mukhtar alam says:

    Thanks sir

  35. Wu吳子健 says:

    A+++

  36. Sania R says:

    wow very nice.

  37. KHALID ALI SubhanAllah says:

    Bundle of Thank Sir

  38. Manjunath Manju says:

    Thanks to helping

  39. Adi - says:

    Thank you so muc.it's really helping me alot doing my jobs and easy to find my drob list data.

  40. Nagaraj Rajagopal says:

    I want get like this below senario

    ex:
    =concatenate("Nagaraj","Rajagopal", "Salem")

    so here
    this content in red color"Nagaraj"
    this content in green color "Rajagopal"
    this content in blue colour "Salem"

  41. Dl De Vera says:

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

  42. Alok Ghosh says:

    How to highlight entire row and column of active cell without making macro…

  43. Gregory Heidt says:

    what if you wanted to assign different colors for each department?

  44. NIJAM PRASAD DEVDAS says:

    Awesome Search Trick Sir .

  45. Sirajul Ripon says:

    your tutorial is so much effective. I really enjoy it!

  46. akosikardia says:

    Wow!! Thank you for this amazing tutorial! My struggle was the formula in formatting… thank you!! 🏁👍🤗🎉

  47. prusharth Vishwakarma says:

    It's awesome but is there a possible if I choose toys from the drop down list it can show the total also

Post a comment