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