I am comparing two rows of numbers that contain an few "N/A" so I have
numbers and text.

How to I use the conditional formatting for this or would a formula be
needed, etc???

Thank you for any assistance you can provide.

Please provide an example of what you are trying to accomplish.

"sweetsue516" wrote:

I am comparing two rows of numbers that contain an few "N/A" so I have
numbers and text.

How to I use the conditional formatting for this or would a formula be
needed, etc???

Thank you for any assistance you can provide.

Here is an example:

5.55 6.78 8.97 6.53 N/A 10.87
4.89 7.98 N/A 10.58 4.32 8.77

If the top column number is higher I would like for the cell in both columns
to be highlighted.

Is this enough or do you need more?


"sweetsue516" wrote:

I am comparing two rows of numbers that contain an few "N/A" so I have
numbers and text.

How to I use the conditional formatting for this or would a formula be
needed, etc???

Thank you for any assistance you can provide.

"sweetsue516" wrote:

Here is an example:

5.55 6.78 8.97 6.53 N/A 10.87
4.89 7.98 N/A 10.58 4.32 8.77

If the top number is higher I would like for the cell in both rows
to be highlighted.

Is this enough or do you need more?


"sweetsue516" wrote:

I am comparing two rows of numbers that contain an few "N/A" so I have
numbers and text.

How to I use the conditional formatting for this or would a formula be
needed, etc???

Thank you for any assistance you can provide.