Advanced filter (1 Viewer)

I imported Excel to Access but lost all Conditional Formatting - so Access is not helpful now. In Excel, I have a baseball card collection entered, player by player, and each row has 10 possible column prices based on card conditions. In Excel, I have a yellow cell background highlight - one per card/row - which is the UNDER THE COLUMN PRICE which I have determined to be the closest for the condition of each card.

I would like to SELECT all details (Columns A-O) of every row WHERE the yellow highlighted cell is >10.

importing imports data, not formatting. Try filtering your excel on the color, copy to a new worksheet and import that. You can probably create a macro in Excel to do the filter and copy.

Otherwise you are into complex vba code to open the spreadsheet, inspect every cell for formatting status and then import the row if required based on the value.

I started a Macro/code to select certain columns and paste into new sheet. Then, I repeated the code with all of the same identifying columns selected and then the "next" different price column selected. However, I'm not sure how the 2nd Copy MUST add the 2nd selection range at the BOTTOM of the 1st range selection. However, the 2nd selection replaces the 1st selection rather than adding the rows right AFTER the 1st rows selected/pasted.

regret I am not an excel guru but looks like you need to go to a different column