Oops.. I missed that it was conditional formatting..

--Select the range A3:I3
--Enter the below formula to format the selected range if H3 and I3 = 1
=AND($H3=1,$I3=1)

--
Jacob


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