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