highlighting
I am using excel 2003
"MartinaPa (MCT)" wrote:
what version of excel do you have?
"excelguy" wrote:
I have 2 columns of numbers. I want to highlight the 4 lowest numbers in the
2 columns. For example, a1=90, a2=100, a3=0, b1=100, b2=100, b3=0, b4=0,
b5=0. In this example, I would want a3, b3, b4, b5 to be highlighted in some
color because they are the 4 lowest numbers out of the 2 columns.
|