A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formula problem with Excel 2010



 
 
Thread Tools Display Modes
  #11  
Old March 11th, 2010, 04:50 PM posted to microsoft.public.excel.worksheet.functions
ker_01
external usenet poster
 
Posts: 87
Default 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.




  #12  
Old March 11th, 2010, 07:12 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Formula problem with Excel 2010

If it objecting to those formulae, is it highlighting the comma? Perhaps
your Windows Regional Options (in Control Panel, not Excel) have specified
your list separator as a semi-colon instead of a comma?
--
David Biddulph


"mns" wrote in message
...
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.





  #13  
Old March 12th, 2010, 05:26 AM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default Formula problem with Excel 2010

Do you mean to return a text string ??

--
Jacob


"Bob Phillips" wrote:

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.






.



.

  #14  
Old March 12th, 2010, 10:42 AM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default Formula problem with Excel 2010

No, I mean to return TRUE or FALSE as your formula did.

--

HTH

Bob

"Jacob Skaria" wrote in message
...
Do you mean to return a text string ??

--
Jacob


"Bob Phillips" wrote:

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.






.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.