Formula is:
=AND(E6<0,E6D6*20%)
--
David Biddulph

"Sean" wrote in message
oups.com...
How do I set a conditional formatting condition in E6 if the value in
E6 is negative and greater than 20% of the value in D6 ?

I wish to copy this conditional formatting to a range of cells, so the
formula would have to be relative

Thanks