Highlight and extract

[SMB618]

I want to use conditional formating to highlight and extract a value between a range.

This range value will vary depending on stock market movement.

In the example sheet attached, I have used Condition Formatting to highlight the range between 6490/6500. This range will vary with each days movement in the stock market.

I just want to extract to a space or new sheet, where I can review in more detail, with the relevant supporting data (as highlighted and extracted as well)..i.e. Column A/B/C/D/E/F/K and S - and showing only Row 1 and 26.