If it objecting to those formulae, is it highlighting the comma? Perhaps
your Windows Regional Options (in Control Panel, not Excel) have specified
your list separator as a semi-colon instead of a comma?
--
David Biddulph


"mns" wrote in message
...
Hi there,
I am trying to enter this formula in conditional formatting window
but my Excel 2010 wont accept it. I get the error "the formula you
entered contains errors".
I tried the formula as
=AND(H3=1,I3=1) and =AND($H$3=1,$I$3=1) doesnt matter.
But when I try it like ="AND(H3=1,I3=1)" Excel accepts this formula
but does nothing:(
My range is =$A$3:$I$3. I cant think of any solutions. help please.