IF - formatting problem
 

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!

IF - formatting problem
 

Hi Stephen

You can do it with CF
Formula Is =(A1-B1)A1=10% format Red
Formula Is =(A1-B1)/A1<=-10% format Yellow

--
Regards
Roger Govier

"Stephen" wrote in message
...
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!

IF - formatting problem
 

Hi Stephen,
Highlight the column and apply conditional formating,

"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!

IF - formatting problem
 

I figured that much but my problem is I'm stuck on the formula.

thanks!

"Eduardo" wrote:

Hi Stephen,
Highlight the column and apply conditional formating,

"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!

IF - formatting problem
 

Hi Stephen,
I assume that in cell C1 you have the formula =(B1/A1)-1, what gives you the
lets say 0.10
Then Highlight the column and go to conditional formating and choose to
highlight with green if the values are greater or equal to 0.10 and with
yelow if they are less than 0.10

"Stephen" wrote:

I figured that much but my problem is I'm stuck on the formula.

thanks!

"Eduardo" wrote:

Hi Stephen,
Highlight the column and apply conditional formating,

"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!

IF - formatting problem
 

Perfect... that's exactly what I was missing.

Thank you both!

"Roger Govier" wrote:

Hi Stephen

You can do it with CF
Formula Is =(A1-B1)A1=10% format Red
Formula Is =(A1-B1)/A1<=-10% format Yellow

--
Regards
Roger Govier

"Stephen" wrote in message
...
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!

IF - formatting problem
 

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!

IF - formatting problem
 

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!

IF - formatting problem
 

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!