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 and this was
the problem I was running into before and have not been able to figure out
how to fix. 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!