| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
| Merge Cells | Excel Discussion (Misc queries) | |||
| Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Hybrid Mode
