Formula problem with Excel 2010
I just tried this in 2010 and it worked fine. I have seen this before, in
some previous Excel version, but I cannot recall the circumstances. If I
remember, I will post back.
--
HTH
Bob
"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.
|