Conditional formating for a column if a cell meets criteria

[mgmugica]

Hello All,

I am working in a Gantt chart and I have a critical date of Jun 20th, I need that if the cell in row 6 is equal to jun 20th the whole column will be highlighed in Red, does any one know how to do it?

Thanks

 

[Gerald Higgins]

Conditional Formating can do this.

In Excel 2003, select the cell in row 6,
Format,
Conditional Formating,
Formula is,

=A$6=date(2011,6,20)

Replace A$6 with whichever cell contains the date.
If your target date can change, and you want to control it by storing it in another cell, replace date(2011,6,20) with the reference for that cell.
Apply a format as required.
Then copy, select the entire column, paste special, formats.

In later versions of Excel I think the menu paths may be slightly different, but the general principle will still apply.