try
=and(not(iserror(upper),upperlower)
in your conditional format formula

"sweetsue516" wrote:

I two rows of data, some numbers and some are N/A.

I need to highlight both rows when the top number is higher but when I use
conditonal formatting it will highlight the cell contain "N/A".

Is there a formula I can use to get around this?

Thank you