Color code cells

[Guest]

I need to color cells in a worksheet to show me when suppliers are late on
responsing to my requests. Can a cell be color coded so that if a supplier
is 7 days late responding it will be yellow and if the supplier is 9 days
late on a response then the cell color can be red, is this possible and if so
how?

Miller

 

[Guest]

Check out conditional formatting in help

 

[Bob Phillips]

Better still, see http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Bob,

Thank you for the web site, I have found some helpful information on the
example section.

Thank you again,
Angela