Hi! I am looking to apply conditional formatting to cells in Column AC when adjacent cells in column AB are not blank.

For example, both columns will have dates. Column AB is start date, Column AC is finish date.

I would like any cell in Column AC to change color when its adjacent cell in Column AB has a date entered IF AC cell is blank. Once cell in AC also has a date, it would return to no fill format. 

​Hi! I am looking to apply conditional formatting to cells in Column AC when adjacent cells in column AB are not blank. For example, both columns will have dates. Column AB is start date, Column AC is finish date. I would like any cell in Column AC to change color when its adjacent cell in Column AB has a date entered IF AC cell is blank. Once cell in AC also has a date, it would return to no fill format.   Read More

​