J
jmcclain
Using Excel 2003...
Trying to compare cells J4:Q4 to cell F4. F4 will be colored yellow if
F4>all cells in the range of J4:Q4 excluding blanks.
If J4 is not >, color the cell (or cells if multiple exist with the same
value) that have the lowest price in the range J4:Q4.
Can anyone suggest the proper formula?
Regards,
Jon
Trying to compare cells J4:Q4 to cell F4. F4 will be colored yellow if
F4>all cells in the range of J4:Q4 excluding blanks.
If J4 is not >, color the cell (or cells if multiple exist with the same
value) that have the lowest price in the range J4:Q4.
Can anyone suggest the proper formula?
Regards,
Jon