Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2022, 08:32 AM
markdtp markdtp is offline Date Conditional Formatting Windows 7 64bit Date Conditional Formatting Office 2021
Novice
Date Conditional Formatting
 
Join Date: Nov 2022
Posts: 1
markdtp is on a distinguished road
Question Date Conditional Formatting

I would like to highlight in colour a date that is within 30 days of todays date in the future.



Example - today is 17/11/2022 - therefore all dates that are between 17/11/2022 and 17/12/2022 should be in colour.

Thanks

Mark
Reply With Quote
  #2  
Old 11-17-2022, 08:57 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Date Conditional Formatting Windows 10 Date Conditional Formatting Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Try =AND($A1>=TODAY(),$A1<=TODAY()+30) as CF
__________________
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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Conditional Formatting stu_c Excel 4 05-22-2022 12:39 AM
Conditional formatting a row based on date cwkotch Excel 1 08-28-2021 10:14 PM
Conditional Formatting based on date teza2k06 Excel 2 11-27-2018 09:55 AM
Date Conditional Formatting Conditional Formatting based on dynamic Date Modifier1000 Excel 2 09-12-2014 08:53 AM
Date Conditional Formatting Date Conditional Formatting teza2k06 Excel 1 08-09-2014 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft