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

[Jane_24]

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 · Accepted solution]

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

Use this in stead:

=ISNUMBER(C2)

[#3]

Thank you so much. @Riny_van_Eekelen