Thread: Formula problem with Excel 2010

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

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

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

--

HTH

Bob

"Jacob Skaria" <JacobSkaria@discussions.microsoft.com> wrote in message
news:5E692591-22D7-4330-B8DC-2801DD343113@microsoft.com...
> 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.
>>
>>
>>
>>

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

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" <mns@discussions.microsoft.com> wrote in message
news:1B0A543A-23FF-44B7-822D-25CDA59C4129@microsoft.com...
> 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.
>
>
>
>

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" <JacobSkaria@discussions.microsoft.com> wrote in message
> news:5E692591-22D7-4330-B8DC-2801DD343113@microsoft.com...
> > 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.
> >>
> >>
> >>
> >>
>
>
> .
>

See my other response.

--

HTH

Bob

"mns" <mns@discussions.microsoft.com> wrote in message
news:19A7B13C-9E34-4289-A278-2FC43879A72C@microsoft.com...
> 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" <JacobSkaria@discussions.microsoft.com> wrote in message
>> news:5E692591-22D7-4330-B8DC-2801DD343113@microsoft.com...
>> > 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.
>> >>
>> >>
>> >>
>> >>
>>
>>
>> .
>>

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" <JacobSkaria@discussions.microsoft.com> wrote in message
> news:5E692591-22D7-4330-B8DC-2801DD343113@microsoft.com...
> > 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.
> >>
> >>
> >>
> >>
>
>
> .
>