asked on
Excel Conditional formatting
I'm struggling setting up conditional formatting in excel for some reason. This is what I am trying to do:
I would like for columns W – AM to be conditionally formatted to change colors 30 days, 60 days, and 90 days prior to expiration. I would like the cells for dates that will expire 30 days from Today() to be bright red, expiring in 60 days to be bright orange and expiring in 90 days to be bright yellow. If the date is already past and it is expired the cell should be black with white font.
Can you point me in the right direction please?
I would like for columns W – AM to be conditionally formatted to change colors 30 days, 60 days, and 90 days prior to expiration. I would like the cells for dates that will expire 30 days from Today() to be bright red, expiring in 60 days to be bright orange and expiring in 90 days to be bright yellow. If the date is already past and it is expired the cell should be black with white font.
Can you point me in the right direction please?
Microsoft ExcelMicrosoft Office
Last Comment
Bembi