Conditional format lowest value greater than zero and copy formula
 

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!

Conditional format lowest value greater than zero and copy formula
 

I'm guessing your CF formula is incorrect.

Assuming you're dealing with cells A1:A100, the conditional format formula
for A1 is:
=A1=MIN(IF($A$1:$A$1000,$A$1:$A$100))

You should now be able to copy this format to the other cells.
(alternatively, if you select all the cells, and make cell A1 active, and
then input this formatting, it will be applied to all the cells with the
correct relative cell references in place.)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gailana" wrote:

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!

Conditional format lowest value greater than zero and copy formula
 

I would say:
* First - select ALL(!) 100 cells.
* Declare the CF relying as per the formula:
=AND(A1=MIN($A$1:$A$100),A10)
*** No need to copy anything now.
Micky


"gailana" wrote:

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!