if you want the whole row to change, make sure you use the absolute cell
reference for the specific cell which you want to determine the color
do you want each cell in the row to change individually.


"Suddz62" wrote:

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!