This might help you

http://www.mvps.org/dmcritchie/excel/condfmt.htm

"John F.M." wrote:


Allow me to establish the context of the situation. In column A I have a
date that a form is received. In column B I want to condition the cells
to display a color contingent on the amount of days that have
transpired since the form was received. Column B actually documents
whether a form has been approved or not. If it has not, then the
appropriate color is displayed. If the form is approved, then the date
of approval is put in the cell with no need for any color. The color is
simply to act as an indicator of the amount of days that have passed
without approval.

For example, let's say that the form was received June 1. The form has
not been approved yet. So, column B would show the color green. Once
two days passes without approval, the cell turns orange. If the form is
not approved by day 5, then the cell in column B turns red. However,
once it is approved, the cell shows the date inputted.

Thanks for the help!


--
John F.M.
------------------------------------------------------------------------
John F.M.'s Profile: http://www.excelforum.com/member.php...o&userid=23782
View this thread: http://www.excelforum.com/showthread...hreadid=376079