Excel 2007 : Conditional formatting for each row (same rule)

Hi all

I am trying to do color scale conditional formatting.

I select the three cells in the same row, then i go to conditional formating -> color scale ->green-yellow-red scale


But when I want to do it for 200 rows (3 cells each), the color scale is not based on a per-row condition. Instead it does it for the whole selection.

Is there a way to do this quickly?

note: these cells are on a pivot table

Originally Posted by adanglst

Hi all

I am trying to do color scale conditional formatting.

I select the three cells in the same row, then i go to conditional formating -> color scale ->green-yellow-red scale


But when I want to do it for 200 rows (3 cells each), the color scale is not based on a per-row condition. Instead it does it for the whole selection.

Is there a way to do this quickly?

note: these cells are on a pivot table

Not exactly sure what you are asking, but try this.

Do your conditional formatting on your three cells. Copy the three cells. Select all the cells below and use Paste Special - Format. That should transfer the formatting the way you want it.