LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 106
Default 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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Problem John Calder New Users to Excel 2 April 6th 09 01:01 PM
Formatting problem Lincoln Burrows Excel Programming 1 December 11th 08 06:15 AM
formatting problem Beth[_2_] Excel Discussion (Misc queries) 3 July 30th 08 03:39 AM
formatting problem ayoubtt Excel Discussion (Misc queries) 0 March 18th 08 07:25 PM
Formatting Problem ROY WAITE Excel Programming 0 December 3rd 07 11:36 AM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"