Forum Discussion

Ryan Thompson's avatar
Ryan Thompson
Copper Contributor
Jun 06, 2017

Conditional formatting based on date entered in another cell

I have a number of columns containing dates and text that pertain to individual action items. In the last column, I want to enter a date when that action item is complete and I'd like all of the relevant cells for that action item to change color.  How can I do this? So, columns A-H have text and dates, column I is empty until I enter a date.

Resources