Forum Discussion
Conditional Formatting for column based off data in another column
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.
Let's say you want to apply this to AC2:AC100.
Select this range; AC2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=AND(AB2<>"", AC2="")
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
Let's say you want to apply this to AC2:AC100.
Select this range; AC2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=AND(AB2<>"", AC2="")
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.- This worked, thank you very much!! I was racking my mind trying to make this work with ISBLANK and NOT(ISBLANK) formulas with failure.
