Formula in Conditional Formatting

[TJAC]

I'm trying to set up a conditional format in my spreadsheet that allows me to
say if cell A1>A2 and A3>A2 then do this, but it won't allow to create this
formula. Can I set this up or is there no way to accomplish this?

Thanks!

 

[Mike H]

Hi,

This should work as a CF formula

=AND(A1>A2,A3>A2)

Mike

 

[Gord Dibben]

Format>CF>Formula is: =AND(A2>A1,(A3>A2))


Gord Dibben MS Excel MVP