I have attempted to work out this problem by researching various sites without locating any thread with a similar problem. Request assistance with Conditional Formatting of a column
listing various Expiration Dates. Conditional formatting necessary to highlight time prior to expriation at 90, 60, and 30 days.
Yellow Between 90 - 61 days of expiration
Amber Between 60 - 31 days of expiration
Red Between 30 - 0 days of expiraton
The closest I have come is getting a couple cells to respond to this conditional formula but they were base on the original cell "S3" in this case.
The formula was static I could not get it to dynamically reflect each seperate row accordingly. I do not think the Format Painter works when using
the Conditional Formatting tools. I tried
Conditional Formatting using a Formula
=IF(S3="","",(IF(TODAY()<S3-90,TRUE,FALSE))) Yellow
=IF(S3="","",(IF(TODAY()<S3-60,TRUE,FALSE))) Amber
=IF(S3="","",(IF(TODAY()<S3-30,TRUE,FALSE))) Red
Conditional formatting using Cell Value
Cell Value between =TODAY()-61 and =TODAY()-90
Cell Value between =TODAY()-31 and =TODAY()-60
Cell Value between =TODAY()-30 and =TODAY()-1
No joy with either attempt.
I have attached a sample of my spreadsheet and my attempts at figuring this out on my own.
Support and any assistance will be truly appreciated. Thank you for your time!
Bookmarks