Forum Discussion
Conditional Formatting based on the date of another column
Hi,
I'm trying to conditionally format cells in column A based on their related to cells of the same row in column J.
Essentially if the date in column A is before the day in column J I want ...
Select I2:I50 or however far down you want. I2 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
=M2<>""
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.