J
john
maybe i explained it wrong..
i tried you suggestion but i get the same result. let me explain.
to be exact..the 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.. i tried to drag the field of D2:H2 with
this format and i tried your suggestion.. however what happens is this, with
both suggestions..
=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
=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
i tried you suggestion but i get the same result. let me explain.
to be exact..the 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.. i tried to drag the field of D2:H2 with
this format and i tried your suggestion.. however what happens is this, with
both suggestions..
=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
=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