#1
|
|||
|
|||
Conditional Formatting Dates
Hi,
I have column G that contains dates. I want to format them so that it will highlight any date that is equal to or less then 5 days old. How do I do this? What formula do I use? Do I even use conditional formatting? Very new at this complex formulas and conditional formatting. Thanks for any help!! |
#2
|
||||
|
||||
Hi
select your range - go to conditional formatting and use following condition for the CF ( assuming you start in G1) Code:
=$G1<=today()-5
__________________
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 |
|
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 |