in Excel 2003
in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday
in cell A1 date of Birth
in cell B1 age with the formula:
=DATEDIF($A1,TODAY(),"Y") & " Years, " & DATEDIF($A1,TODAY(),"YM") & " Months, " & DATEDIF
($A1,TODAY(),"MD") & " Days"
with the conditional formatting:
=TEXT($B1,"DD/MM")-TEXT(TODAY(),"DD/MM")=0
which works perfectly
but in worksheet2, I have in cell B1 the formula
=worksheet1!B1
with the same conditional formatting which does not work
How can I make cell B1 in worksheet2 be highlighted when today is the birthday?