Thread: [Solved] Conditional Format Dates Due in X Days
View Single Post
 
Old 04-10-2020, 03:41 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Select A1:A100
Ribbon: Home tab, Styles section, Conditional Formatting ,choose New Rule…
Choose Use a formula to determine which cells to format
Enter this formula:
=$A1-TODAY()=3
click the Format… button and format as you want it to appear
Click OK twice
Reply With Quote