Conditional formatting

S

sweetsue516

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

sweetsue516

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?
 
S

sweetsue516

sweetsue516 said:
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?
Click to expand...
 
Top