View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karthik
 
Posts: n/a
Default How can I get an expired date to automatically be highlighted?

Suppose you are having the dates from col A1 to A6.
Select the col A1:A1
Go to FormatConditional formatting
Select Formula is from the drop down below condition1 and enter
=($A1<TODAY()) in the next cell and select format and select any colour
from patterns and say apply

Hope this is what you are looking for

Karthik