View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Danger Alex Danger is offline
external usenet poster
 
Posts: 2
Default 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