![]() |
verify data with macro?
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??? |
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??? |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com