Conditional formatting only numeric

[strongman86]

Guys,

Got 2 columns to compare using conditional formatting to highlight if cell value is greater than adjacent cell value, but only cells containing numbers need to highlighted.

Thanks.

 

[Johnny C]

In the conditional format, select 'use a formula' and enter this

=AND(ISNUMBER($G3),$G3>$F3)

or whatever column letters you need and $'s if appropriate.

 

[strongman86]

Thanks Johnny C. Works perfect.