Change font color if date in column F is prior to today's date.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Change font color if date in column F is prior to today's date.

12-05-2018, 07:35 PM

NoSparks

Windows 7 64bit Change font color if date in column F is prior to today's date.

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

have you tried changing the 11 to a 6 or F in quotes ("F") ?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting a Date in Date Picker and Having it change dates throughout	joshuaran	Word VBA	2	03-14-2018 09:24 PM
Change a part of date or the number color	Jazzis	Excel	3	10-15-2016 01:49 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM
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 03:09 PM.