[jlojones821]

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!

[Gary''s Student]

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!

[jlojones821]

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!

[Jim Thomlinson]

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!

[Dave]

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.

[jlojones821]

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]

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