Creating a sheet to highlight lowest ten in a given column

Hello,

First thanks for any advice given.

I understand how to do basic pivot tables, conditional formatting, etc.. But a friend asked me if I could help her create way to paste a report into a sheet and then that data is moved to a table with the results or some other way. (Hope that makes sense!)

Attached is an example of the data on the report. There is a Field column but only three fields will be really looked at. So after you filter it to certain field, only three other columns are really looked at. In those columns they only want to see the bottom 10.

So when they swtich to a field they want to see the person's name, area, store.. then when they filter by the other columns it will automatically switch to the bottom 10 and highlight them red. Do this for each of the fields in question.

Does that make sense and if so is it possible?

Again, thanks for the help and I will be more than happy to try and explain further.

.
https://www.teachexcel.com/free-exce...utoFilter.html

Hmm. Never worked with macros but will give it a shot. Thanks!