Hi all! I have a workbook with 2 sheets, I am trying to get information to move from my equipment sheet to my dashboard sheet based on the conditional formatting. Basically when the status column has a conditional formatting of less than or equal to 29 cell turns red. Between 30 & 59 cell is orange, between 60 and 90 is yellow and greater than 90 cell is green. I want to have this information automatically move from the equipment sheet to the dashboard sheet when it gets to the red and yellow status. Below are snips of my sheets.

Capture.PNGCapture3.PNG