Auto Moving information based on conditional formatting

**klabant** · 06-09-2014, 10:01 AM

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.PNG Capture3.PNG

**klabant** · 06-09-2014, 11:04 AM

Or would I be better off using the pivot table to generate this?

**ChemistB** · 06-09-2014, 03:58 PM

An uploaded spreadsheet (Go Advanced>Manage Attachments) would help a lot.

For Description on Sheet2
=INDEX(Sheet1!$A$2:$A$100, SMALL(IF($H$2:$H$100>90, ROW($A$2:$A$100)-ROW($A$2)+1),ROWS($A$2:$A2)))
entered as an ARRAY
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.