Hi,
Is it possible to use conditional formatting to color a row based on the value outside of the row?
I have a large table with different deliveries and their information. I want to color an entire row yellow if it's been delivered within the past 3 days and red if it was delivered more than 2 weeks ago. I have set up a formula using the TODAY function that gives the number of days since delivery.
From what I saw within creating a new rule in Conditional Formatting, I couldn't find anything that didn't apply solely directly the cell with the days since delivery.
Thanks!
Bookmarks