Conditional Formatting Applied Per Row

[kreestar]

To get a quick dashboard of per-area sales, I've applied Color Scale conditional formatting to an array of data in a pivot table (column labels = day of month):

Excel 2007
	A	B	C	D	E	F	G	H
1	Sales (Formatted for entire area)	1	2	3	4	5	6	7
2	Area 1	770	185	753	769	314	323	279
3	Area 2	465	139	498	494	470	448	456
4	Area 3	490	155	497	495	412	430	401
5	Area 4	12	13	14	56	47	20	3
6	Area 5	1	1	212	215	201	228	200
7	Area 6	185	64	128	108	140	137	140
Sheet1

This is useful in a sense, but pretty useless in seeing how, for example, Area 4's sales are stacking up against itself historically. If I apply the Conditional Color Scale formatting one row at a time, that does the job: Allows me to see the peak for Area 4 on Day 5. Also highlights the drop in sales from Area 1 on Day 2 (which is hidden in the all-records formatting).

Quick Question is: How can we apply Conditional formatting based on Cell Value only to records in the same row.

Sorry, doesn't allow me to copy and paste the cell colours/formatting

Thanks so much!

Kree