The worksheet has two rows which have numbers and some cells contain "N/A".

If the number in the top row is highest both top and bottom number need to
be highlighted in yellow. If the top number is lowest or contains "N/A" the
background needs to remain white.

The conditional formatting works great until the cell with the "N/A". Excel
views this as higher the any number.

Does anyone have any suggestion for this.

Thank you in adavance.