Need solution to formula problem

[Guest]

Help please!

I have two rows of numbers with some cell that will contain 'N/A".

If the top row is highest I need it highlighted yellow if it is not highest
or is "N/A" the cell needs to remain with no fill.

I can do a condtional formatting that works great until a cell contains the
"N/A". Is there a formula that I can do in conditional formatting or some
other options that will solve this problem.

 

[Max]

As suggested in your multi-post in .programming
(please do not multi-post)

Try this ..

Select rows 1 & 2, and apply cond format
Cond1's formula: =A$1="N/A" ("No format set")
Cond2's formula: =A$1>A$2 (set fill color: yellow)