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