How do I auto-populate cells based on what is in another cell?

[lkorner]

Hi,This has probably been answered somewhere else but I can't seem to find anything close enough to what I need (and my Excel knowledge is fairly basic)!I have a large spreadsheet that tracks various projects. When a project is complete i change the '% Complete' column to 100% but when I do that I want 2 other cells to change to 'Complete'How do I do this?Thanks for your help!

 

[Scrappy666]

=if(A1=1,"Complete","")

Try that, A1 being the % cell