| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding data to coloured cells
I am using excel 2000 I have a very large spreadsheet used for staff scheduling, each day a person works the cell is coloured red Is it possible to find each red cell and enter 1, so that I can do some analysis on days worked etc Thanks in advance Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=556790 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding data to coloured cells
You could try filtering by colour then do so. See
http://www.rondebruin.nl/easyfilter.htm -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Paul Sheppard" wrote in message news:Paul.Sheppard.2a5hjn_1151562302.1993@excelfor um-nospam.com... I am using excel 2000 I have a very large spreadsheet used for staff scheduling, each day a person works the cell is coloured red Is it possible to find each red cell and enter 1, so that I can do some analysis on days worked etc Thanks in advance Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=556790 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Adding up data in multiple cells for a single criteria. | Excel Worksheet Functions | |||
| Importing Data | Excel Worksheet Functions | |||
| Using data from coloured cells in a chart | Excel Worksheet Functions | |||
| REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Linear Mode
