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