Conditional formatting based on another cell’s value
Note: when it says “B5” in the explanation below, it actually means “B{current_row}”, so for C5 it’s B5, for C6 it’s B6 and so on. Unless you specify $B$5 – then you refer to one specific cell. This is supported in Google Sheets as of 2015: https://support.google.com/drive/answer/78413#formulas In your case, you will need to set … Read more