Formula problem with Excel 2010

mns-

You mention that you can enter CF on single cells and have it work as
expected. I don't use 2010, but I suspect this will work on any version.

Select cell A3 (single cell only)
Put in your CF formula: =AND($H3=1,$I3=1) along with your desired formatting
Select cell A3 and click on format painter
Select row 3 (and additional rows, if desired)

HTH,
Keith


"mns" wrote:

Jacob, thanks for replay. I cannot enter that formula too.
Let me underline where I enter the formula again.

I select a range of cells on a row. (=$A$3:$I$3)
Then I hit conditional formatting and add a new rule.
I select Use a formula to determine which cells to format.
then I cannot enter anything like =IF(AND(H3=1,I3=1),"True","False") this.
Somehow excel says formula contain errors. If I edit my formula like
="IF(AND(H3=1,I3=1),"True","False")" then Excel accepts it but nothing
changes.

note that if I enter =H3=1 then it checks for that cell for that value and
if its
ture some coloring happens(as i arranged). cant enter abit more compex
formulas

"Jacob Skaria" wrote:

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.