Conditional formatting [Closed]

Report
Posts
1
Registration date
Sunday February 7, 2016
Status
Member
Last seen
February 7, 2016
-
I am creating a dashboard to monitor the metrics of several facilities. This spreadsheet has a summary page and each facility has their own sheet to enter their data against their goal and there is conditional formatting to make the cells red or green based on if they met the goal. I want to create a dashboard that will bring in the data and it's conditional format into the summary sheet but I am having trouble trying to determine how to bring in the conditional format from the facility level sheet.