Need solution to formula problem

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.

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)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sweetsue516" <sweetsue516@discussions.microsoft.com> wrote in message
news:6CDB35B4-FDBC-4D81-BE13-38B2FE72336E@microsoft.com...
> 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.