conditional formatting
 

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

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

conditional formatting
 

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

conditional formatting
 

You could also use:

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


Linda RQ wrote:

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

--

Dave Peterson

conditional formatting
 

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

conditional formatting
 

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

"Peo Sjoblom" wrote in message
...
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

conditional formatting
 

That worked great too Dave. Thanks for answering

Linda

"Dave Peterson" wrote in message
...
You could also use:

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


Linda RQ wrote:

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

--

Dave Peterson

conditional formatting
 

Sure Linda, thanks for the feedback

--


Regards,


Peo Sjoblom


"Linda RQ" wrote in message
...
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

"Peo Sjoblom" wrote in message
...
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