I apologize to the OP :)

--


Regards,


Peo Sjoblom


"John" wrote in message
...
HI Peo
For future posts indicate what version of Excel you are using "
You're reading to fast or you need a good cut of coffee,She started her
post typing " Excel 2003"
Lack of coffee will do that.
John

"Peo Sjoblom" wrote in message
...
For future posts indicate what version of Excel you are using since the
methods are different

Select C3, do formatconditional Formatting, use formula is, in the
formula box put


=TEXT(B3,"mm/dd/yyyy")=TEXT(D3,"mm/dd/yyyy")

click the format button and select font, then bold and click OK twice




For 2007, select C3, click the conditional formatting icon on the home
tab, select new formatting rule, select use formula etc, in the box below
put the same formula in there, then format and select font and bold


--


Regards,


Peo Sjoblom


"Linda RQ" wrote in message
...
Excel 2003. Beginner user here. I have Cell C3 with a date and time.
I have Cell D3 with a date and time. I want Cell C3 to become bold text
if the date only is the same as the date in cell C3.

C3 12/1/09 08:20 (bold text because the date is equal)
D3 12/1/09 13:20

I tried using conditional formatting but only the dates and times that
are exactly the same are bold. I need the conditional formatting to
ignore the time.

Thanks,
Linda