conditional formatting for ratios between rows?

[Alex Danger]

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

 

[Guest]

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.

 

[MacDAD]

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

 

[Alex Danger]

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.