How to make cells in one column change colour based on corresponding cells in another column?
Hi,
I’m trying to make the cells in column A become green when there is a date in the corresponding row in column C. I found a formula that worked =C2<=TODAY() when applied to A2, but when I tried to make it apply to the whole range on A2:A13, all the cells in column became green. But I only want A2, A3, A4, A10 & A11 to become green because they have a date in the corresponding cell in column C. Thank you in advance.
Hi, I’m trying to make the cells in column A become green when there is a date in the corresponding row in column C. I found a formula that worked =C2<=TODAY() when applied to A2, but when I tried to make it apply to the whole range on A2:A13, all the cells in column became green. But I only want A2, A3, A4, A10 & A11 to become green because they have a date in the corresponding cell in column C. Thank you in advance. Read More