Updating Window With Color
There is an Excel file that teaches how to perform the Updating Window With Color operation.
Excel Solution: Updating Window with Color
This workbook demonstrates updating window with color using VBA macros on a 3-row data layout.
Hope it is useful.