SOLVED

# How to make cells in one column change colour based on corresponding cells in another column?

Copper Contributor

# 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.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: How to make cells in one column change colour based on corresponding cells in another column?

@Jane_24 That's because dates are numbers and the date number value for today is 45427. The value of a blank cell is always less than TODAY(), hence all cells in A are formatted.

=ISNUMBER(C2)

# Re: How to make cells in one column change colour based on corresponding cells in another column?

Thank you so much. @Riny_van_Eekelen

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: How to make cells in one column change colour based on corresponding cells in another column?

@Jane_24 That's because dates are numbers and the date number value for today is 45427. The value of a blank cell is always less than TODAY(), hence all cells in A are formatted.