View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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!