Highlighting a cell

[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.

 

[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

 

[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...

 

[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]

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?