| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reading a blank cell as zero
I'm a first time poster so please be patient if I don't give enough detail.
I'm trying to put an if stmt in one cell and conditionally format that cell. My current formula is =IF(D10=0,D10,NA()). But when D10 is blank it puts a zero in E10 and thus my conditional format colors the cell. What I want is #NA to appear in E10 which blocks the conditional formatting. This seems easy enough but wont work. I've tried different formulas with no luck. Thanks for any help. Dana |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading a cell in VBA | New Users to Excel | |||
| Reading last cell | Excel Discussion (Misc queries) | |||
| Reading formulae in a different cell | Excel Discussion (Misc queries) | |||
| Reading Cell Function??? | Excel Worksheet Functions | |||
| reading blank cell as active - how can I stop it ? | Excel Discussion (Misc queries) | |||
Threaded Mode
