| 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. |
| 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) | |||
Threaded Mode
