Conditional Formatting Date Expirations

Hello,

I am attempting to use conditional formatting icons (flags) to highlight when inputs in a database are coming close to their expiration date. I understand that the icons can easily be used for percentages and that this formula can work on an individual basis using: =TODAY()+CELL<=90, however I am unsure how to combine the two approaches. In this instance, an example of what I am attempting to achieve is having the dates 12/04/2024, 01/05/2023, 15/12/2022 being formatted green, yellow and red retrospectively (potentially highlight <=90 days, <=365 days and 366+ days remaining). The database has hundreds of rows and therefore would not be feasible to format each one individually with the formula I know. Would anyone be able to assist me with this?

Best regards,
Brandon