Conditional format with isnumber

[adame]

Hi,
I have a conditional format that is working for me: =INDEX($BI$38:$BK$59,MATCH($AI11,$BH$38:$BH$59,0),MATCH(AJ$10,$BI$37:$BK$37,0))<50 (thanks to @AliGW)

Please could someone let me know how to add something like isnumber, so cells do not format if any of reference cells ($BI$38:$BK$59) contain a hyphen?

Many thanks,

Adam

[Special-K]

=and(index($bi$38:$bk$59,match($ai11,$bh$38:$bh$59,0),match(aj$10,$bi$37:$bk$37,0))<50,
isnumber(index($bi$38:$bk$59,match($ai11,$bh$38:$bh$59,0),match(aj$10,$bi$37:$bk$37,0))))

[AliGW]

You can add another CF rule to deal with this after the other two.

[adame]

Sorry to be a pain, but how would I do that? I have tried, but no luck. I do struggle with CF.
A

[adame]

Thanks Special-K, I will use this solution as back up as I have several of these rules and am hoping for an easier fix.
A

[AliGW]

Attach your current workbook and I will show you.

[adame]

Attached, thank you - I would like cell f4 not to be highlighted.
A

[AliGW]

Change the rule to this:

=AND(INDEX($E$14:$G$16,MATCH($D4,$D$14:$D$16,0),MATCH(E$3,$E$13:$G$13,0))>50,E4<>"")

Make sure you have cell E4 selected when you edit the rule.

[adame]

Will do, many thanks for your help. Have a great weekend.
Adam