Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2016, 12:31 AM
Jazzis Jazzis is offline Change a part of date or the number color Windows 7 64bit Change a part of date or the number color Office 2010 64bit
Novice
Change a part of date or the number color
 
Join Date: Oct 2016
Posts: 2
Jazzis is on a distinguished road
Question Change a part of date or the number color


Hello everyone!
Why can not I change the color part of date or the number?
Reply With Quote
  #2  
Old 10-15-2016, 12:51 AM
xor xor is offline Change a part of date or the number color Windows 10 Change a part of date or the number color Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

I don't have the slightest idea what you mean.
Reply With Quote
  #3  
Old 10-15-2016, 01:22 AM
Jazzis Jazzis is offline Change a part of date or the number color Windows 7 64bit Change a part of date or the number color Office 2010 64bit
Novice
Change a part of date or the number color
 
Join Date: Oct 2016
Posts: 2
Jazzis is on a distinguished road
Default

I have the date in the cell: 12.06.2016. How do I change color only part of the date? To date was as follows: 12.06.2016. But this type of data was date.
Reply With Quote
  #4  
Old 10-15-2016, 01:49 AM
xor xor is offline Change a part of date or the number color Windows 10 Change a part of date or the number color Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

When I enter a date I do it as: dd-mm-yyyy
Entered that way I can't format individual part of the date. If I change it to text by entering 'dd-mm-yyyy I can format mm with red color (highlight mm and select red font color).

You may be able to do the same if you enter '12.06.2016

If 12.06.2016 is entered as date or generated by formula you can't format part of the date.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change a part of date or the number color Cell Color based on date jrfoley3 Excel 3 08-26-2016 10:49 PM
Change a part of date or the number color Choose color for different number range secoo140 Excel 9 10-07-2013 12:12 PM
Date display in Mod quick part header Jrul John Word 1 08-02-2010 12:17 PM
Change a part of date or the number color Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft