FG

Excel 2007: Conditional formatting so that each row shows low values yellow, high values red

Fresh3 days ago
Mar 15, 202666134 views
Confidence Score0%
0%

Problem

I have a spreadsheet with approx 300 rows. Each row has about 15 columns, and each cell contains a numeric value. Each row corresponds to a product. I want to get Excel, for each product, to highlight the cells with the highest numbers in red and the lowest numbers in yellow, with a gradient for nu…

Error Output

1 2 3
4 5 6
7 8 9

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel 2007: Conditional formatting so that each row shows low values yellow, high values red

Low Risk

Here's a macro that creates a conditional format for each row in your selection. It does this by copying the format of the first row to EACH row in the selection (one by one, not altogether). Replace B1:P1 with the reference to the first row in your…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment