If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|