conditional formatting - problem with text cell value from formula

[PBcorn]

I wish to apply conditional formatting with three conditions based on the
cell value, resulting in three different shading colors. The cells have
formulae with if statements that return "n/a" if one of the referenced cells
contain "n/a" or are blank.

this results in the conditional formatting applying the color for the
condition >0 when the cell value is "n/a" - i want it to leave these alone
(i.e. no color)

please help

 

[ryguy7272]

I think you should see this:
http://www.contextures.com/xlCondFormat03.html

=ISNA(A1)


Regards,
Ryan---

 

[PBcorn]

Problem solved - here is the solution:

cond. 1:

formula is =IF(ISBLANK(H9),"",IF(H9<-5%,H9,""))

cond. 2:

formula is =IF(ISBLANK(H9),"",AND(H9>=-5%,H9<=0%))

cond 3:

formula is: =IF(ISBLANK(H9),"",IF(H9>0%,H9,""))

this ignores all cells with text values and all blank cells.