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 ...
Hi Hayley,
You need to apply two rules, one for each color. For example, for the green
New rule-> Use the formula...
and
=$A1<$J1
applying to your range
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.
