Conditional Formatting that will ignore text

[c hassett]

Hi All me again,
Got the stats working great thanks to the advice from those who replied.

I now want to apply conditional formating that will not occur if the cell value is "G", "F", "/".

I've got it working fine with numerical values that are not in range of the result of statistical testing. However the cells that have G, F or / also have the conditional formatting applied and I don't want it to.

Thanks in advance for the helping me.

 

[xld]

add a test of

=AND(D2<>"G",D2<>"F",D2<>"/")

 

[c hassett]

Got it working using the error codes listed in cells and then conditional formating to match and treat them without any format.

 

[lenze]

Just add ISNUMBER to you CF
=(YourcurrentCFformula)*ISNUMBER(A1)

lenze