Forum Discussion
Ryan Thompson
Jun 06, 2017Copper Contributor
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.
Hi Ryan,
Yes, use the rule like
=$I2>0
and apply it to your $A:$H columns
- Ryan ThompsonCopper Contributor
Wow, as simple as that. Thank you very much!