I have built a calendar in excel. Each day is made up of seven rows to put
todo monthly type items which is basically enough for one day. An example of
a item may be 'Fund Payroll - SG' and another item may be 'Co 1 F/S due - SG'
and these occur each month so each one will have at least 12 occurances. The
payroll will have 24 because there are 24 paydays in the year. My question
is how can I select at the same time all cells containing '- SG'. I want to
do this becuase as a user enters the system I want to color their
responsibility cells with color code 36, ie. the light yellow. But another
issue is I want to color their cells with code 36 only if the cells
Interior.ColorIndex < xlnone. This is because I have all the
responsibilities with Interior.ColorIndex = 35 until the task is complete at
which time I make the Interior.ColorIndex = xlnone and therefore do not want
to Interior.ColorIndex the cell to 36 if the task is already completed and
the Interior.ColorIndex = xlnone.

Summary: All responsibility cells are colored with index = 35. When a user
enters I want to select all their cells identified with the, for example, ' -
SG' and test if the cell color index is not xlnone then I want to change it
to colorindex = 36 so their responsibility will be light yellow and all the
other responsibilites will show as light green.

This was a long explanation of the problem and I thank you very much for
your help.

Steven