Formula in Conditional Formatting
 

I'm trying to set up a conditional format in my spreadsheet that allows me to
say if cell A1A2 and A3A2 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!

Formula in Conditional Formatting
 

Hi,

This should work as a CF formula

=AND(A1A2,A3A2)

Mike

"TJAC" wrote:

I'm trying to set up a conditional format in my spreadsheet that allows me to
say if cell A1A2 and A3A2 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!

Formula in Conditional Formatting
 

FormatCFFormula is: =AND(A2A1,(A3A2))


Gord Dibben MS Excel MVP


On Wed, 10 Sep 2008 06:29:01 -0700, TJAC
wrote:

I'm trying to set up a conditional format in my spreadsheet that allows me to
say if cell A1A2 and A3A2 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!