Conditional Formatting Dates

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting Dates

FAQ

Thread Tools

Display Modes

12-06-2014, 10:59 AM

Pecoflyer

Windows 7 64bit Conditional Formatting Dates

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Hi
select your range - go to conditional formatting and use following condition for the CF ( assuming you start in G1)

Code:

=$G1<=today()-5

and format as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Dates	Phil H	Excel	6	12-08-2014 07:42 AM
Conditional Formatting/If Statement with Dates	AndrewEnos	Excel	2	07-22-2014 07:34 AM
Conditional Formatting - color only dates contained in a range	EC37	Excel	1	07-08-2014 12:51 PM
Conditional Formatting - past due dates	namedujour	Excel	1	06-27-2014 04:16 PM
Conditional Formatting with Dates	namedujour	Excel	1	02-21-2013 03:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:05 AM.