Color-code numbers (heat map)
Color the numbers in B2:F500 from red (low) through yellow to green (high).
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Three-color scale on B2:F500
Use it in MacroRoni: open the Starter gallery, search for "Color-code numbers (heat map)", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More reports macros
ReportsMake a report look professionalDark header row, banded rows, borders, frozen header and fitted columns.Doesn't change valuesReportsPrint-ready reportLandscape on one page wide, header repeated on every page, page numbers in the footer.Doesn't change valuesReportsSave the sheet as a PDFFit the sheet to the page and save it as a PDF next to the workbook.Doesn't change values