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 expiration date cell is red for Oil, how do I get the name cell "Oil" to turn RED too? Thanks
1 Reply
- You have to use conditional formatting. something like
=AND(ExpirationDateCell>0,ExpirationDateCell<=30)
Show some of sample from your data.
