excell windows 03 cond format help
 

thank you for your time!
i have a worksheet that i use to compare the prices of 400 different items,
with 5 different companies . but i would like to format the cells to
automatically change color showing the cheapest price. i have already done
this manually going row by row.. but is there a quick way to drag that
conditional format down?

to be exact..the active field rows D2 : D400 are the 400 items
and colums D : H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in row D.. =D2=MIN($D$2:$H$2) with a color
format to black pattern and white font... i tried to drag the field of D2:H2
with
this format .. however what happens is this..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers in each of the 400 rows
final row was
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for each
row...D2 to D400. this took me over an hour... i was just hoping someone
knew how to do
the easy format.
thnx jt

excell windows 03 cond format help
 

To quickly drag the format down, use right-click.

On the fill character (the little black box on the bottom right of the cell),
right-click and drag the cell down as far as you want.

When you release the button, Excel will give you a menu. Choose Fill Formatting
Only.

--
Regards,
Fred


"john" wrote in message
...
thank you for your time!
i have a worksheet that i use to compare the prices of 400 different items,
with 5 different companies . but i would like to format the cells to
automatically change color showing the cheapest price. i have already done
this manually going row by row.. but is there a quick way to drag that
conditional format down?

to be exact..the active field rows D2 : D400 are the 400 items
and colums D : H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in row D.. =D2=MIN($D$2:$H$2) with a color
format to black pattern and white font... i tried to drag the field of D2:H2
with
this format .. however what happens is this..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers in each of the 400 rows
final row was
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for each
row...D2 to D400. this took me over an hour... i was just hoping someone
knew how to do
the easy format.
thnx jt

excell windows 03 cond format help
 

Select D2:H400
Use Format | Conditional Formatting
In the dialog use: "Cell Value Is" - "Equal to" - =MIN(D$16:D$24) and set
the colour
Note where the $ signs are in the formula
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"john" wrote in message
...
thank you for your time!
i have a worksheet that i use to compare the prices of 400 different
items,
with 5 different companies . but i would like to format the cells to
automatically change color showing the cheapest price. i have already
done
this manually going row by row.. but is there a quick way to drag that
conditional format down?

to be exact..the active field rows D2 : D400 are the 400 items
and colums D : H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in row D.. =D2=MIN($D$2:$H$2) with a color
format to black pattern and white font... i tried to drag the field of
D2:H2
with
this format .. however what happens is this..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers in each of the 400
rows
final row was
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for each
row...D2 to D400. this took me over an hour... i was just hoping someone
knew how to do
the easy format.
thnx jt

excell windows 03 cond format help
 

fred, i get the same thing.. the first D cell number changes but the other
two remain the same as the field i drug down
now keep in mind i need to drag all 5 rows D:H with the format. if i right
click on D2, i can not slide it over through H2 as i could with a left click.
so i tried highlighting D2:H2 then right click, drag, fomat only.. but the
same outcome. i tried right clicking D2 and dragging then right clicking E2
etc.. same result
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2)

thank you!

"Fred Smith" wrote:

To quickly drag the format down, use right-click.

On the fill character (the little black box on the bottom right of the cell),
right-click and drag the cell down as far as you want.

When you release the button, Excel will give you a menu. Choose Fill Formatting
Only.

--
Regards,
Fred


"john" wrote in message
...
thank you for your time!
i have a worksheet that i use to compare the prices of 400 different items,
with 5 different companies . but i would like to format the cells to
automatically change color showing the cheapest price. i have already done
this manually going row by row.. but is there a quick way to drag that
conditional format down?

to be exact..the active field rows D2 : D400 are the 400 items
and colums D : H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in row D.. =D2=MIN($D$2:$H$2) with a color
format to black pattern and white font... i tried to drag the field of D2:H2
with
this format .. however what happens is this..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers in each of the 400 rows
final row was
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for each
row...D2 to D400. this took me over an hour... i was just hoping someone
knew how to do
the easy format.
thnx jt

excell windows 03 cond format help
 

not even close..that format compares all the prices of all the items .. i am
comparing prices only in colum D E F G & H in row 2
then prices in colum D E F G & H in row 3
to .................. D E F G & H in row 400
thnx for trying!
"Bernard Liengme" wrote:

Select D2:H400
Use Format | Conditional Formatting
In the dialog use: "Cell Value Is" - "Equal to" - =MIN(D$16:D$24) and set
the colour
Note where the $ signs are in the formula
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"john" wrote in message
...
thank you for your time!
i have a worksheet that i use to compare the prices of 400 different
items,
with 5 different companies . but i would like to format the cells to
automatically change color showing the cheapest price. i have already
done
this manually going row by row.. but is there a quick way to drag that
conditional format down?

to be exact..the active field rows D2 : D400 are the 400 items
and colums D : H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in row D.. =D2=MIN($D$2:$H$2) with a color
format to black pattern and white font... i tried to drag the field of
D2:H2
with
this format .. however what happens is this..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers in each of the 400
rows
final row was
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for each
row...D2 to D400. this took me over an hour... i was just hoping someone
knew how to do
the easy format.
thnx jt

excell windows 03 cond format help
 

Get rid of the $ signs in front of the row reference in order to increment cell
references.

=D2=MIN($D2:$H2) dragged down will produce

=D3=MIN($D3:$H3)
=D4=MIN($D4:$H4)


Gord Dibben MS Excel MVP

On Wed, 17 Jan 2007 16:06:01 -0800, john wrote:

fred, i get the same thing.. the first D cell number changes but the other
two remain the same as the field i drug down
now keep in mind i need to drag all 5 rows D:H with the format. if i right
click on D2, i can not slide it over through H2 as i could with a left click.
so i tried highlighting D2:H2 then right click, drag, fomat only.. but the
same outcome. i tried right clicking D2 and dragging then right clicking E2
etc.. same result
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2)

thank you!

"Fred Smith" wrote:

To quickly drag the format down, use right-click.

On the fill character (the little black box on the bottom right of the cell),
right-click and drag the cell down as far as you want.

When you release the button, Excel will give you a menu. Choose Fill Formatting
Only.

--
Regards,
Fred


"john" wrote in message
...
thank you for your time!
i have a worksheet that i use to compare the prices of 400 different items,
with 5 different companies . but i would like to format the cells to
automatically change color showing the cheapest price. i have already done
this manually going row by row.. but is there a quick way to drag that
conditional format down?

to be exact..the active field rows D2 : D400 are the 400 items
and colums D : H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in row D.. =D2=MIN($D$2:$H$2) with a color
format to black pattern and white font... i tried to drag the field of D2:H2
with
this format .. however what happens is this..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers in each of the 400 rows
final row was
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for each
row...D2 to D400. this took me over an hour... i was just hoping someone
knew how to do
the easy format.
thnx jt

excell windows 03 cond format help
 

for comparing 5 cells in columns D-H..highlight the minimum price in each row
or item...

on cell D2
conditional format
formula is : =d2=min($d2:$h2)
choose color pattern e.g green
copy cell d2 and select range d2:h400

note: if a company has no price on one item, leave the cell as blank..
--
*****
birds of the same feather flock together..



"john" wrote:

thank you for your time!
i have a worksheet that i use to compare the prices of 400 different items,
with 5 different companies . but i would like to format the cells to
automatically change color showing the cheapest price. i have already done
this manually going row by row.. but is there a quick way to drag that
conditional format down?

to be exact..the active field rows D2 : D400 are the 400 items
and colums D : H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in row D.. =D2=MIN($D$2:$H$2) with a color
format to black pattern and white font... i tried to drag the field of D2:H2
with
this format .. however what happens is this..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers in each of the 400 rows
final row was
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for each
row...D2 to D400. this took me over an hour... i was just hoping someone
knew how to do
the easy format.
thnx jt

excell windows 03 cond format help
 

It worked for me!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"john" wrote in message
...
not even close..that format compares all the prices of all the items .. i
am
comparing prices only in colum D E F G & H in row 2
then prices in colum D E F G & H in row 3
to .................. D E F G & H in row 400
thnx for trying!
"Bernard Liengme" wrote:

Select D2:H400
Use Format | Conditional Formatting
In the dialog use: "Cell Value Is" - "Equal to" - =MIN(D$16:D$24) and set
the colour
Note where the $ signs are in the formula
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"john" wrote in message
...
thank you for your time!
i have a worksheet that i use to compare the prices of 400 different
items,
with 5 different companies . but i would like to format the cells to
automatically change color showing the cheapest price. i have already
done
this manually going row by row.. but is there a quick way to drag that
conditional format down?

to be exact..the active field rows D2 : D400 are the 400 items
and colums D : H are the prices
i want to know what price is the cheapest of each collum D-H by a color
format.
the color format is not an issue...

now this is the formula i put in row D.. =D2=MIN($D$2:$H$2) with a
color
format to black pattern and white font... i tried to drag the field of
D2:H2
with
this format .. however what happens is this..
=D2=MIN($D$2:$H$2)
=D3=MIN($D$2:$H$2)
=D4=MIN($D$2:$H$2) ...... etc ending at
=D400=MIN($D$2:$H$2)

what i ended up doing is changing the two numbers in each of the 400
rows
final row was
=D400=MIN($D$2:$H$2) to =D400=MIN($D$400:$D$400) in the formula for
each
row...D2 to D400. this took me over an hour... i was just hoping
someone
knew how to do
the easy format.
thnx jt