Elizabeth

You could use Conditional Formatting to color the cells.

Select the cells with will get the yes or no and FormatCFCondition1Cell
Value is: "yes"
Format to a color.

AddCondition2Cell Value is" "no"
Format to a color.


Gord Dibben MS Excel MVP


On Thu, 16 Nov 2006 12:35:01 -0800, Elizabeth
wrote:

I'm trying to set up a workbook where by I have a list of items pending. once
completed i would enter either yes or no.
i want to set up a Macro to move these items/or colour code them.

is there any way to set up a data validation/macro to do this???