Set a Conditional Formatting Q

[Sean]

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

 

[David Biddulph]

Formula is:
=AND(E6<0,E6>D6*20%)

 

[Sean]

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








- Show quoted text -

Thanks David