This question already has an answer here:
I'm trying to set up a spreadsheet the will color the background of a cell based on the text within another cell. This would have to be set up in a row so that if (for example) B2: contained "done", then A2 would be colored green. Likewise for B3 and A3, B4 and A4, etc. I understand how conditional formatting works, I just don't know what formula to use to accomplish this.