View Single Post
 
Old 07-30-2016, 02:57 PM
desireemm1 desireemm1 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 4
desireemm1 is on a distinguished road
Default conditional Formating for dates greater than 3weeks or more

Hello I am not that good at excel and I am trying to highlight cells that have dates greater than a certain number of weeks to be either yellow, green or red

Im trying to add two dates together in two different columns and if the outcome is greater than 21 days =hightlight yellow
Greater than 28 days = Hightlight Green
Greater than 14 days = hightlight Red
Reply With Quote