Fill cells with color depending on the value of OTHER cells

[uvgery]

Namely, let's say i have a list of names in one column and birth dates in the next. I created rules in conditional formatting, to fill the cells of the birthdays with color, depending on the date upon data entry. Also want the cells with the names to be filled with same color upon writing in the birthday, don't want to copy paste formatting only from one column to the other. Is there a solution for this? Thank you very much in advance

 

[Jon Peltier]

When you define your rule, use mixed referencing so the column but not the row has $ preceding it.

So if the rule to define the color in cell C2 is

=YEAR(C2)<2014

then use this slightly modified rule in C2:D2:

=YEAR($C2)<2014