T
tupperboysx3
Is it possible to format a cell using a formula such as the following:
Column L uses an X to signify that a crime report due date has an expiration
of 14 days. The date of the crime is listed in column B. How do you format
Column H to signify if the date entered in Column H has expired (greater than
14 days past the date in Column B)? I would like the cells in Column H to
change color if the date entered is 14 days past the date of the crime in
Column B.
I am using Excel 2003
Column L uses an X to signify that a crime report due date has an expiration
of 14 days. The date of the crime is listed in column B. How do you format
Column H to signify if the date entered in Column H has expired (greater than
14 days past the date in Column B)? I would like the cells in Column H to
change color if the date entered is 14 days past the date of the crime in
Column B.
I am using Excel 2003