Do you *really* want the entire columns of D, E, F, and H to be included in
the Conditional Format?

If you do, then click on the column header of Column H, to select the entire
column, then hold down <Ctrl, and click in the headers of F, E, and D, in
that order, so that you end up with cell D1 in focus (white).

Then,
<Format <Conditional Format
Change to "Formula Is", and enter this formula:

=D1=MIN($D:$F,$H:$H)

Click on "Format", and choose your Bold (or whatever), then <OK <OK.

Now, the lowest number in either of those 4 columns will display with the
format that you chose.
Needless to say, ties ( for lowest) will all display the chosen format.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------



"dbrumit" wrote in message
...
Hi Don, I could not get the formula below to work

What we have are columns: D,E,F,& H which have prices, these prices change
from time to time, so we would like the lowest price to be bold.

Thanks again for all of your help

Dan

"Don Guillett" wrote:

try it like this
=a1=min($d$1:$f$10,$h$1:$i$10)
--
Don Guillett
SalesAid Software

"dbrumit" wrote in message
...
I originally stated that I wanted the highest value, but it is the
lowest
value that I need, so I changed max to min and that worked. I now need
to
apply this to the whole column. I actually need columns D E F H

If we cant skip column G, I can have them all run together.

Thank you very much for your help!

Dan


"Don Guillett" wrote:

try formula is
=a1=max($a$1:$c$1)

--
Don Guillett
SalesAid Software

"dbrumit" wrote in message
...
I would like the the font of the highest value of 3 cells.
A1,B1,C1 to
be
large.

Thanks