verify data with macro?

[Elizabeth]

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???

 

[Gord Dibben]

Elizabeth

You could use Conditional Formatting to color the cells.

Select the cells with will get the yes or no and Format>CF>Condition1>Cell
Value is: "yes"
Format to a color.

Add>Condition2>Cell Value is" "no"
Format to a color.


Gord Dibben MS Excel MVP