I'm doing a price comparison on food products from many different companies.
Is it possible to have it automatically highlight the cell that contains the
lowest price in it? Or do I just need to do it manually?

Thanks!

Use Conditional formatting.
--
Gary''s Student - gsnu200792


"jlojones821" wrote:

I'm doing a price comparison on food products from many different companies.
Is it possible to have it automatically highlight the cell that contains the
lowest price in it? Or do I just need to do it manually?

Thanks!

But how do I set it up so it compares one cell against a bunch of others....I
can figure it out for comparing one cell....my brain is just fried today


"Gary''s Student" wrote:

Use Conditional formatting.
--
Gary''s Student - gsnu200792


"jlojones821" wrote:

I'm doing a price comparison on food products from many different companies.
Is it possible to have it automatically highlight the cell that contains the
lowest price in it? Or do I just need to do it manually?

Thanks!

Use conditional formatting something like this. Switch to Formula is and your
formula will look like

=A1=min(A$1:A$10)

So if A1 is equal to the smallest value in A1:A10 then it will be formatted...
--
HTH...

Jim Thomlinson


"jlojones821" wrote:

But how do I set it up so it compares one cell against a bunch of others....I
can figure it out for comparing one cell....my brain is just fried today


"Gary''s Student" wrote:

Use Conditional formatting.
--
Gary''s Student - gsnu200792


"jlojones821" wrote:

I'm doing a price comparison on food products from many different companies.
Is it possible to have it automatically highlight the cell that contains the
lowest price in it? Or do I just need to do it manually?

Thanks!

Hi,
Use Jim's formula in the CF, but select all your data first. Then the CF
will be applied to all your data, automatically adjusted to each cell's
requirements.
Regards - Dave.

I'm still having some issues....it isn't a continuous group of cells....it is
like cell c258 then cell k258, etc... Any easy ideas?

"jlojones821" wrote:

I'm still having some issues....it isn't a continuous group of cells....it is
like cell c258 then cell k258, etc... Any easy ideas?


I'm still having problems......is there any other formula that I can use?