I am using Excel 2007 but cannot get the conditional formatting to work
correctly. I have 100 rows of data. In the 1st row I need to fill the cell
with color if it's the lowest value greater than $0. Then I need to copy that
conditional format to the next 99 rows.

The conditional formating only works if the cell that's $0 is blank.

After I select the 1st row, copy, paste special, formats, it only works on a
few of the rows. The rest don't show any color. If I paste special 1 row at a
time, it works.

Thanks for any help!