Change row colour for complete tasks

[browne09]

I want to change the colour of the row to green when my 'project status' is inputted at 100%. Is there a way I can do this?

 

[Fluff]

You could use conditional formatting.
Select your data & Conditional formatting > New rule > use a formula >
=$Z2=1
then select your format & OK.

change the Z2 to reflect the project status column, als0 the row number need to match the first row in the applies to range

 

[browne09]

Brilliant! Thank you!!

 

[Fluff]

Glad to help & thanks for the feedback