Thread: Conditional formatting to show if date has passed
View Single Post
 
Old 04-11-2024, 02:14 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
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
use formulae in conditional formatting such as for amber:
Code:
=TODAY()=DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))
for green:
Code:
=TODAY()>DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))
for red:
Code:
=TODAY()<DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))
See attached
Attached Files
File Type: xlsx msofficeforums52349.xlsx (9.3 KB, 3 views)
Reply With Quote