I'm making a chart to see which vendor has the lowest price for the same product. I have 4 values (F4, I4, L4 and O4). I would like to have the lowest value of the cell use the "data validation" option and make the cell a light green (or whatever color I choose).
How can I do this?
Thank you and have a Merry CHRISTmas.
craigwojo
How can I do this?
Thank you and have a Merry CHRISTmas.
craigwojo