I have a spreadsheet that has 4 colors on it that need to be sorted automatically separated by two blank cell. the Colors are done using a conditional format. What i need it to look like is below. there will be muiltiple lines, and i would like it to move when the cell color changes based on todays date. the data starts in A2 with a header. Also can this be applied to 12 sheets?
<TBODY>
</TBODY>
A | B | C | D | ||
PVT | NAME |
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||
<30 DAYS | |||||
PVT | NAME | 5-FEB-13 | 5-FEB-14 THIS CELL IS YELLOW | ||
30-60 DAYS | |||||
PVT | NAME | 12-MAR-13 | 12-MAR-14 THIS CELL IS ORANGE | ||
61+ DAYS | |||||
PVT | NAME | 14-APR-13 | 14-APR-14 THIS CELL IS GREEN |
<TBODY>
</TBODY>