Chg row color if certain criteria is met

[Suddz62]

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.

 

[bj]

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

 

[Suddz62]

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?

 

[Suddz62]

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?

 

[bj]

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.