| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula problem with Excel 2010
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula problem with Excel 2010
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula problem with Excel 2010
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula problem with Excel 2010
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula problem with Excel 2010
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" 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula problem with Excel 2010
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" 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. . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula problem with Excel 2010
See my other response.
-- HTH Bob "mns" wrote in message ... 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" 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. . |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula problem with Excel 2010
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. . |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula problem with Excel 2010
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. . |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I set up a pop-up calendar for 2010 in Excel? | Excel Discussion (Misc queries) | |||
| UDF's via Automation Addin in Excel 2010? | Excel Worksheet Functions | |||
| Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM | Excel Worksheet Functions | |||
| 2010 date in Excel 2000 | Excel Discussion (Misc queries) | |||
| 2010 in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
