conditional formatting entire column referencing data from other c

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.

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 FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=G1I1
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Jamie" wrote:

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.

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/ =G1I1

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.
--
David Biddulph

"Jamie" wrote in message
...
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.