Copying Abolute formulas and conditional formats

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" <JerryFoley@discussions.microsoft.com> wrote in message
news:C36DF56E-D13E-4950-A7D4-95B7DD696081@microsoft.com...
> 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" <JerryFoley@discussions.microsoft.com> wrote in message
> news:C36DF56E-D13E-4950-A7D4-95B7DD696081@microsoft.com...
> > 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" <JerryFoley@discussions.microsoft.com> wrote in message
news:DC16694C-16EE-454C-A3EB-85880E98D350@microsoft.com...
> 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" <JerryFoley@discussions.microsoft.com> wrote in message
> > news:C36DF56E-D13E-4950-A7D4-95B7DD696081@microsoft.com...
> > > 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)
> > >
> > >
> >
> >
> >