| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can color codes be used in formulas to seperate data?
I have a pay sheet that has a cell that we use for leave can I use colors
i.e. red=sick leave blue=annual leave green=leave without pay and hve it transfer that information to the appropriate column in another document in excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can color codes be used in formulas to seperate data?
Hi Phazer,
Take a look at this site. http://xldynamic.com/source/xld.ColourCounter.html HTH Martin "Phazer" wrote in message ... I have a pay sheet that has a cell that we use for leave can I use colors i.e. red=sick leave blue=annual leave green=leave without pay and hve it transfer that information to the appropriate column in another document in excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color format cells based on list in seperate worksheet | Excel Worksheet Functions | |||
| Transpose Color Formatting to Seperate Worksheet | Excel Worksheet Functions | |||
| How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
| how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
| color codes | Excel Worksheet Functions | |||
Linear Mode
