Thread: Date Conditional Formatting
View Single Post
 
Old 05-18-2022, 01:50 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
Here you go!

I set the Conditional Format for overtime, you can easily add formats for various warnings (adding/removing the number of years/months in DATE() function in formula),
Attached Files
File Type: xlsx Training.xlsx (10.4 KB, 6 views)
Reply With Quote