Require a Macros in Excel

February 16, 2011 at 06:45:50
Specs: Windows Vista
I need help, that if you click a particular cell the row turns green, or if you click a different cell the row turns red. The cell you click also requires to show the current time when clicked. It is show on a computer screen who is attendance to a meeting and when the people have arrived.

See More: Require a Macros in Excel

Report •

February 16, 2011 at 16:57:02
I would use a checkbox. Is there any reason you have to have color?

You could do an if-checked and color the background of the checkbox. You could execute via a button or macro to update or create a final show list.

You might even want to create an if statement to copy and sort to other sheets for show and no-show.

:) Go Wild. LOL

I'm learning.

Report •
Related Solutions

Ask Question