verify data with macro?
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???
|