conditional formatting
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
|