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?
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]PVT
[/TD]
[TD]NAME
[/TD]
[TD][TABLE="width: 113"]
<TBODY>[TR]
[TD="align: right"]0-Jan-00</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 135"]
<TBODY>[TR]
[TD="align: right"]30-Dec-00
[/TD]
[/TR]
</TBODY>[/TABLE]
THIS CELL IS RED
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]<30 DAYS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PVT
[/TD]
[TD]NAME
[/TD]
[TD]5-FEB-13
[/TD]
[TD]5-FEB-14
THIS CELL IS YELLOW
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30-60 DAYS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PVT
[/TD]
[TD]NAME
[/TD]
[TD]12-MAR-13
[/TD]
[TD]12-MAR-14
THIS CELL IS ORANGE
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]61+ DAYS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PVT
[/TD]
[TD]NAME
[/TD]
[TD]14-APR-13
[/TD]
[TD]14-APR-14
THIS CELL IS GREEN
[/TD]
[/TR]
</TBODY>[/TABLE]
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]PVT
[/TD]
[TD]NAME
[/TD]
[TD][TABLE="width: 113"]
<TBODY>[TR]
[TD="align: right"]0-Jan-00</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][TABLE="width: 135"]
<TBODY>[TR]
[TD="align: right"]30-Dec-00
[/TD]
[/TR]
</TBODY>[/TABLE]
THIS CELL IS RED
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]<30 DAYS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PVT
[/TD]
[TD]NAME
[/TD]
[TD]5-FEB-13
[/TD]
[TD]5-FEB-14
THIS CELL IS YELLOW
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30-60 DAYS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PVT
[/TD]
[TD]NAME
[/TD]
[TD]12-MAR-13
[/TD]
[TD]12-MAR-14
THIS CELL IS ORANGE
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]61+ DAYS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PVT
[/TD]
[TD]NAME
[/TD]
[TD]14-APR-13
[/TD]
[TD]14-APR-14
THIS CELL IS GREEN
[/TD]
[/TR]
</TBODY>[/TABLE]