Change a part of date or the number color

		Microsoft Office Forums > Microsoft Excel > Excel
Change a part of date or the number color

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-15-2016, 01:49 AM

xor

Windows 10 Change a part of date or the number color

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell Color based on date	jrfoley3	Excel	3	08-26-2016 10:49 PM
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
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 04:38 PM.