Even if it is not CF, the IF is redundant.

--

HTH

Bob

"Jacob Skaria" wrote in message
...
I didnt notice that the query is on CF..and thought the OP is trying to
return a text string from the condition....

--
Jacob


"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.






.