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$1A$2 (set fill color: yellow)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"sweetsue516" wrote in message
...
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.