conditional formatting entire column referencing data from other c

[Jamie]

I have 2 columns of dates - G and I. I want the cell in column I to
conditionally format when the date in Column G is later than the date in
Column I. I can do this one at a time, but I need the entire column.

 

[Jacob Skaria]

Conditional formatting automatically applies to all the cells in the selection.

1. Select the column I or a range (say I1:I100) Please note that the cell
reference I1 mentioned in the formula is the active cell in the selection.
Active cell will have a white background even after selection

2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=G1>I1
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

If this post helps click Yes

 

[David Biddulph]

Select the whole of column I, then as I1 is the active cell, use either
CF/ cell value is/ less than/ =G1
or
CF/ Formula is/ =G1>I1

Another way is to just select cell I1, format as above, then use Format
Painter or Copy and Edit/ Paste Special/ Format to apply to the rest of your
column.