Help w/ cell shading across entire column-when a criteria has been

  • Thread starter Thread starter lilly8008
  • Start date Start date
L

lilly8008

I have a column that I would like to change color once an certain criteria
has been met.

Example:
Column A Cells --A1:A23 has various dates 01/02/09-08/10/09.

A:125 has date of 12/01/09.

Once the date of 12/01/09 has been entered in any cell within the range of
A1:A124 I want the entire column to change color.
 
Back
Top