conditional formatting for ratios between rows?
 

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

conditional formatting for ratios between rows?
 

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

conditional formatting for ratios between rows?
 

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

conditional formatting for ratios between rows?
 

On Jul 30, 7:36 pm, MacDAD
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.