Is there an easy way to copy the below example conditional format with
absolute vales to 247 lines in an Excel spreadsheet?

=A1=MIN($A$1:$A$4)

Select all 247 lines, go into CF and add the formula. The absolutes will be
imposed on each cell, the relatives will adjust to each cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry Foley" wrote in message
...
Is there an easy way to copy the below example conditional format with
absolute vales to 247 lines in an Excel spreadsheet?

=A1=MIN($A$1:$A$4)

Hey Bob,
thanks for the help. I must be having a senior moment but I cannot seem to
get it to work.
My data cells are G5-K5 down to 246. I want to test the rows g-k and place
the reulting lowest value in the corresponding colume l. I want to highligjt
the lowest value in another color. I have accomplished this on only single
rows by highliting g5-k5 and using =min(g5:k5) and then CF to make the color
change using =g5=min($g$5:$k$5).

I am have copied the formula to do the lowest value comparison but I am
having issues copying the CF to all of the other lines at one time. Can you
help out again?

Thanks in advance.

Jerry
"Bob Phillips" wrote:

Select all 247 lines, go into CF and add the formula. The absolutes will be
imposed on each cell, the relatives will adjust to each cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry Foley" wrote in message
...
Is there an easy way to copy the below example conditional format with
absolute vales to 247 lines in an Excel spreadsheet?

=A1=MIN($A$1:$A$4)

Hey Jerry,

Are you trying to highlight the lowest value on each row, or the minimum
difference in G & K columns over all rows?

If the former, then select all of the cells in columns G & K, and in CF, use
a formula of

=G5=MIN($G5:$K5)

If the latter, select all of the cells in columns G & K, and in CF, use a
formula of

=($G5-$K5)=MIN($G5:$K5)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry Foley" wrote in message
...
Hey Bob,
thanks for the help. I must be having a senior moment but I cannot seem to
get it to work.
My data cells are G5-K5 down to 246. I want to test the rows g-k and place
the reulting lowest value in the corresponding colume l. I want to
highligjt
the lowest value in another color. I have accomplished this on only single
rows by highliting g5-k5 and using =min(g5:k5) and then CF to make the
color
change using =g5=min($g$5:$k$5).

I am have copied the formula to do the lowest value comparison but I am
having issues copying the CF to all of the other lines at one time. Can
you
help out again?

Thanks in advance.

Jerry
"Bob Phillips" wrote:

Select all 247 lines, go into CF and add the formula. The absolutes will
be
imposed on each cell, the relatives will adjust to each cell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry Foley" wrote in message
...
Is there an easy way to copy the below example conditional format with
absolute vales to 247 lines in an Excel spreadsheet?

=A1=MIN($A$1:$A$4)