conditional formatting

[Linda RQ]

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

 

[Peo Sjoblom]

For future posts indicate what version of Excel you are using since the
methods are different

Select C3, do format>conditional 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

 

[John]

HI PeoYou'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

 

[Dave Peterson]

You could also use:

Formula is:
=int(c3)=int(d3)
(=int() will take the whole number (the date) and ignore the fraction (the
time).)

 

[Peo Sjoblom]

I apologize to the OP

--


Regards,


Peo Sjoblom

 

[Linda RQ]

Hey, no need to apologize. If I had used proper grammer you would have
noticed. Besides, your help is really appreciated and it worked great. I
still have much more to do with this data and learn so keep me in your
radar.

Thanks,
Linda

 

[Linda RQ]

That worked great too Dave. Thanks for answering

Linda

 

[Peo Sjoblom]

Sure Linda, thanks for the feedback

--


Regards,


Peo Sjoblom