GOOGLE SHEETS: Importrange/Filter/Query Trying to copy data from one sheet with its conditional format

[Kbester]

https://docs.google.com/spreadsheets/d/1-f4cUjN5BB0jICErbVqpRA5oyumSLjlMS0xRI6U-PgQ/edit?usp=sharing


Hi,

I know this is not a googlesheets forum but I'm desperate. I used this forum last year for excell with great results .... fingercroseed.


I'm trying to copy the data in this sheet from today's date to the dashboard. I have managed to do it but I would like to be able to do it with its conditioning.


ANy ideas?


In the dashboard I basically just need to see whos data and what data has highlighted in red so needs action. The issues is that each column for each person has different conditional formatting based on standard deviation away from their means.


ANy help or ideas would be greatly appreciated as I have been going for the last few days on this.


Thanks


Kath