Trying to base format on date in cells

Good morning all,



I have a worksheet that formats the cell containing the last date an item was issued when it is within 30, 60 or 90 days of the annual issue date. How do I get the entire row to match the date cell format when it changes?

I appreciate your help.

Andrew.