conditional formatting

L

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
 
P

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
 
J

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
 
D

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).)
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top