Thread: Change a part of date or the number color
View Single Post
 
Old 10-15-2016, 01:49 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
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