Forum Discussion
Color Coding Multiple cells based on dates
I formatted my Expiration Dates for color codes at 30 days (Red) and 60 days (Yellow) . How do I color code the Item Name to correspond with the date color code at the same time? Example: If the ex...
You have to use conditional formatting. something like
=AND(ExpirationDateCell>0,ExpirationDateCell<=30)
Show some of sample from your data.
=AND(ExpirationDateCell>0,ExpirationDateCell<=30)
Show some of sample from your data.