verify data with macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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