Copying Abolute formulas and conditional formats

[Jerry Foley]

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)

 

[Bob Phillips]

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]

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]

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)