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)