formula for different cell contents
 

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.

formula for different cell contents
 

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
...
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.