Color row based on sum of 2 cells in row

Unsolved

I'm creating a tracker for a MtG collection and would like to keep track of what I have and which ones are foil. I have a checkmark for both, and besides user error I'll never have "Foil" checked without "Have".

I want to color the row red if neither are checked, white if one is checked, and purple if both are checked. I don't know how to do this. I have it set so Unchecked = 0 and Checked = 1.

I also can't figure out how to conditional format based on other cells without making a new rule for each row, which is infeasible because there are 480 rows I want to do this to.

Posted Nov 1, 2025, 11:51 PM UTC

110
Loading comments…