Conditional formatting

Closed
cndwillis
Posts
1
Registration date
Sunday February 7, 2016
Status
Member
Last seen
February 7, 2016
- Feb 7, 2016 at 02:38 PM
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.