highlight birthday in a referenced cell

[Hany0]

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?

[pecoflyer]

In the future please check in which forum you are posting.
This topic was in the " Tips and Tutorials " section...