Adding data to coloured cells

[Paul Sheppard]

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

[Bob Phillips]

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" <Paul.Sheppard.2a5hjn_1151562302.1993@excelforum-nospam.com>
wrote in message
news:Paul.Sheppard.2a5hjn_1151562302.1993@excelforum-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
>