yes thank you guys but the problem is i cannot use
=AND($H3=1,$I3=1). Thats what is the problem:( excel says there is an error.
I am using office 2010

i can enter formula if i type like ="AND($H3=1,$I3=1)" this. This is my
problem

"Bob Phillips" wrote:

The IF is totally unnecessary, =AND(H3=1,I3=1) returns TRUE or FALSE which
is what CF requires.

--

HTH

Bob

"Jacob Skaria" wrote in message
...
Do you mean

=IF(AND(H3=1,I3=1),"True","False")

--
Jacob


"mns" wrote:

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.






.