0
votes
1answer
3 views

Google Sheets: Evaluating each cell in a row based on the cell adjacent to it

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", ...