Dears,
If I have a report that contains customer information and my task is to highlight mistakes. once I finish highlighting mistakes I need to keep only the records/rows with that contains any highlighted cell. how can I do that?
Dears,
If I have a report that contains customer information and my task is to highlight mistakes. once I finish highlighting mistakes I need to keep only the records/rows with that contains any highlighted cell. how can I do that?
hi Vitorio. do an Autofilter. select the data you need (say A1:F10), then go to Data tab -> Autofilter. or press CTRL + SHIFT + L. then click on the column where the colours are. filter by Color -> No Fill. delete those rows.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
how can you know that the info has mistake in it.
You could post a sample workbook.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
We have to do that using filtering and for some rows, manually. but once done and highlighted in yellow, I need to remove all rows that has no coloring as it contains no mistakes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks