PC Review


Reply
Thread Tools Rate Thread

conditional formatting for ratios between rows?

 
 
Alex Danger
Guest
Posts: n/a
 
      30th Jul 2007
Hi folks,

I have been unable to create the following conditional formatting rule
for the following data:

Column 1
value1
value2
value3
value 4


What I want is conditional formatting for an entire column such that a
cell is coloured IF (value1/value2) exceed a certain ratio (or (value1
- value2) > some other value). It needs to be the same down the whole
column: ie value2/value3, value3/value4 etc.

I have many columns that require this formatting but I can not figure
out how to achieve it. Can anyone help?

Regards,

Alex

 
Reply With Quote
 
 
 
 
=?Utf-8?B?Sm9lbA==?=
Guest
Posts: n/a
 
      30th Jul 2007
To copy conditional formating use the paintbrush con the formating toolbar.
Are you having problems copying the format or creating the format? No clear
from your instructions. Normal copying will not copy the conditional formatt.

"Alex Danger" wrote:

> Hi folks,
>
> I have been unable to create the following conditional formatting rule
> for the following data:
>
> Column 1
> value1
> value2
> value3
> value 4
>
>
> What I want is conditional formatting for an entire column such that a
> cell is coloured IF (value1/value2) exceed a certain ratio (or (value1
> - value2) > some other value). It needs to be the same down the whole
> column: ie value2/value3, value3/value4 etc.
>
> I have many columns that require this formatting but I can not figure
> out how to achieve it. Can anyone help?
>
> Regards,
>
> Alex
>
>

 
Reply With Quote
 
MacDAD
Guest
Posts: n/a
 
      30th Jul 2007
What you can try is when doing the conditional formatting, take out
the dollar signs and then copy the cell with the conditional
formatting and paste special formats. That normally works

 
Reply With Quote
 
Alex Danger
Guest
Posts: n/a
 
      30th Jul 2007
On Jul 30, 7:36 pm, MacDAD <teshlin.aka...@momentumaspire.co.za>
wrote:
> What you can try is when doing the conditional formatting, take out
> the dollar signs and then copy the cell with the conditional
> formatting and paste special formats. That normally works


Thanks guys, I got it figured.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting many rows javablood Microsoft Excel Misc 2 13th Jul 2009 06:13 PM
Conditional Formatting 2 rows only Tamara Microsoft Excel Misc 2 15th May 2008 10:41 PM
RE: Conditional formatting rows =?Utf-8?B?a2Fzc2ll?= Microsoft Excel Misc 0 6th Jan 2007 05:45 PM
Conditional formatting for rows? =?Utf-8?B?RlRN?= Microsoft Excel New Users 4 8th Nov 2006 04:07 PM
Conditional Formatting of Rows aposatsk Microsoft Excel Misc 1 1st Aug 2006 04:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:52 PM.