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.

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Ryan,

     

    Yes, use the rule like

    =$I2>0

    and apply it to your $A:$H columns