Color code cells
 

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

Color code cells
 

Check out conditional formatting in help

"Angela" wrote:

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

Color code cells
 

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

--
HTH

Bob Phillips

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

"bj" wrote in message
...
Check out conditional formatting in help

"Angela" wrote:

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

Color code cells
 

Bob,

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

Thank you again,
Angela

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"bj" wrote in message
...
Check out conditional formatting in help

"Angela" wrote:

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