IF - formatting problem

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

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!
 
Hi Stephen

You can do it with CF
Formula Is =(A1-B1)>A1>=10% format Red
Formula Is =(A1-B1)/A1<=-10% format Yellow
 
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
 
For multiple recipienets, pass an array each element of which is one
recipient. E.g,

Recipients:=Array("(e-mail address removed)","(e-mail address removed)","(e-mail address removed)")

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

I think your in the wrong thread.

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

Recipients:=Array("(e-mail address removed)","(e-mail address removed)","(e-mail address removed)")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
Click to expand...
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting macro: simple, but doesn't work 6
Need urgent help 0
custom function color 2
Conditional formatting based on numbers in columns 5
Time Calculations Help 4
Conditional Formatting Formula 2
Background color change, by using the formula. 1
Color 3

Back
Top