verify data with macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elizabeth - 16 Nov 2006 20:35 GMT

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

Reply to this Message

Gord Dibben - 16 Nov 2006 21:29 GMT

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

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

Reply to this Message

Rate this thread: