Condition Format syntax

  • Thread starter Thread starter Paul Hyett
  • Start date Start date
P

Paul Hyett

I have pairs of cells to test.

What I want to check is if the value of the 2nd cell is higher than the
first, but less than 1.5 times as high.

I've tried various syntax combinations using 'Formula is', but just
can't seem to hit the right one (Excel 2003).

Can anyone help?
 
Use "Formula Is", then:

=AND(B1<A1*1.5,B1>A1)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have pairs of cells to test.

What I want to check is if the value of the 2nd cell is higher than the
first, but less than 1.5 times as high.

I've tried various syntax combinations using 'Formula is', but just
can't seem to hit the right one (Excel 2003).

Can anyone help?
 
Use "Formula Is", then:

=AND(B1<A1*1.5,B1>A1)
Click to expand...

Thank you for this - just what I was looking for! :)

Also, thanks to Per Jessen, but this formula is more concise.
 
Back
Top