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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|