Conditional Formatting
 

I two rows of data, some numbers and some are N/A.

I need to highlight both rows when the top number is higher but when I use
conditonal formatting it will highlight the cell contain "N/A".

Is there a formula I can use to get around this?

Thank you

try
=and(not(iserror(upper),upperlower)
in your conditional format formula

"sweetsue516" wrote:

I two rows of data, some numbers and some are N/A.

I need to highlight both rows when the top number is higher but when I use
conditonal formatting it will highlight the cell contain "N/A".

Is there a formula I can use to get around this?

Thank you

bj,

It says I have too many arguments in this formula.

"bj" wrote:

try
=and(not(iserror(upper),upperlower)
in your conditional format formula

"sweetsue516" wrote:

I two rows of data, some numbers and some are N/A.

I need to highlight both rows when the top number is higher but when I use
conditonal formatting it will highlight the cell contain "N/A".

Is there a formula I can use to get around this?

Thank you

bj,

would you like to see if there is another way?

"sweetsue516" wrote:

bj,

It says I have too many arguments in this formula.

"bj" wrote:

try
=and(not(iserror(upper),upperlower)
in your conditional format formula

"sweetsue516" wrote:

I two rows of data, some numbers and some are N/A.

I need to highlight both rows when the top number is higher but when I use
conditonal formatting it will highlight the cell contain "N/A".

Is there a formula I can use to get around this?

Thank you

Use Conditional formating under the format menu option. Use "cell is" less
than and place the cell location in the third block (A2). Condition the
other cell as follows 'Cell is" Greater than and refer to the first cell
(A1). Also click format in the lower right side and choose pattern from the
tabs and click the color you want. You can copy the first two cells A1 and
A2 and paste SPECIAL, choose "formats" when you paste special.

Good luck

"sweetsue516" wrote:

bj,

would you like to see if there is another way?

"sweetsue516" wrote:

bj,

It says I have too many arguments in this formula.

"bj" wrote:

try
=and(not(iserror(upper),upperlower)
in your conditional format formula

"sweetsue516" wrote:

I two rows of data, some numbers and some are N/A.

I need to highlight both rows when the top number is higher but when I use
conditonal formatting it will highlight the cell contain "N/A".

Is there a formula I can use to get around this?

Thank you