Ok, that worked out good, but I have a couple of cell that weren't
highlighted because the have both letters and numbers in them. Any
suggestion on how to get these cells included also in the row color change?
--
Thx for your help!


"bj" wrote:

check out conditional formatting in help
Format-conditional format-formula is =cell=100%

"Suddz62" wrote:

How do I make my worksheet chg the row color to a specific color if a cell
equals 100%, but if the cell is between 1 - 99% chg the row color to a
different color.
--
Thx for your help!