Heat Mapping multiple rows at the same time

You could copy the one row and paste formats to each row in turn instead of applying CF to each row, or you can use a macro.

Select your blocks of data (using click-drag, ctrl-click-drag, etc.) and run this macro:

Please Login or Register  to view this content.