I think your in the wrong thread.

Yep.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 5 Jan 2009 08:48:01 -0800, Stephen
wrote:

Hey Chip!

I think your in the wrong thread.

"Chip Pearson" wrote:


For multiple recipienets, pass an array each element of which is one
recipient. E.g,

"," ")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 5 Jan 2009 05:27:00 -0800, Stephen
wrote:

Hi Folks,

I have two columns that calculate out to be percentages. I'd like to
compare one against the other and color the cell based on a +/- 10%.

ei; A1 = 90% B1 = 100%

-since A1 is - 10% of B1, then color cell A1 font color Red.

**

ei; A1 = 100% B1 = 90%

-since A1 is + 10% of B1, then color cell A1 cell color Yellow.

I'm not sure if I can do this with straight up conditional formatting or if
I need this to run in some sort of code?

Any help is greatly appreciated!

TIA!