Program to change the Excel cell to a different color.

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

Guest

Hi,

In Excel, I'd like to be able to click on a check box and have the cell that
the checkbox is on turn a certain color. For example, I have 4 cell boxes
A1-D1 with check boxes added in the middle of each cell. I'd like to be able
to click on the checkbox on A1 and have that cell turn green, then on B1 and
that cell turn yellow, then on C1 turn Red and D1 also turn red. Then I'd
like to also be able to click on each cell after they've turned their colors
and have it go back to it's original white cell.

Thanks
 
Where did you get the checkboxes from? The control toolbox toolbar or the
forms toolbar?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting based on numbers in columns 5
How do I use Conditinal Format for another cell? 1
Change Row Color using VBA 3
Changing cell color by clicking the cell 2
Remove Hyperlinks Without Changing background shading 14
Copying a Picture From Cell Comment 0
Changing Cell Properties when sheet is protected 1
Using function to change a cell color 8

Back
Top