Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
Need to know how to assign colors to different cells when a certain set of
initials are typed into a cell. I have 4 crews with 7 individuals and need to keep track of pm's that are completed. Would like to set up so that a color comes up for each crew. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
Steve --
Use conditional formatting. Select the cell(s), then FormatConditional Formatting. Set it so that it checks to see if the cell value is equal to (for example) S07, and then set the format for text and background color. You can have up to three conditional formats so, including no special format, you can handle four possibilities this way. HTH "steveo0707" wrote: Need to know how to assign colors to different cells when a certain set of initials are typed into a cell. I have 4 crews with 7 individuals and need to keep track of pm's that are completed. Would like to set up so that a color comes up for each crew. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |