Forum Discussion
Solved
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 A...
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.