conditional formatting for ratios between rows?

A

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
 
J

Joel

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.
 
M

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
 
A

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.
 

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

Top