Color Coding Multiple cells based on dates

Occasional Visitor

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.