conditional formatting entire column referencing data from other c

  • Thread starter Thread starter Jamie
  • Start date Start date
J

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.
 
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
 
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.
 
Back
Top