Google Sheets: Format cell background based on a value in a cell in another sheet
My problem: sometimes I forget to review published interviews for a talk.
I publish a weekly interview series, the "PostgreSQL Person of the Week" interviews. The data lives in a big spreadsheet, which has several sub-sheets.
The first one, the main sheet, is holding the overall status of all interviews, and has one column which indicates if the interview is complete.
Another sheet, the fifth one, holds the statistics data for my talk about what I learned interviewing the community.
The first column in the fifth sheet is copying the name from the first sheet. The second column indicates if I already looked over the interview and gathered all the statistics. And this is where today's problem came up: whenever I finished an interview (over 100 of them already) I marked this second column with a question mark ("?") to let myself know that at some point I need to read the interview again. But of course I don't always remember to do that.
My idea was to color the background of this cell, based on the value in the first sheet: make the cell background green when the interview is completed. This gives me an instant indication if I need to work on this interview or not.
Turns out this is a bit complicated, but possible.
Continue reading "Google Sheets: Format cell background based on a value in a cell in another sheet"