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

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