Conditional Formatting For Multiple Users On A Group Sheet

[Mooncake]

Super new here, but I've been dabbling with Excel for a couple of years.

I've been tasked with creating a group sheet.
Clicking 1 of 5 buttons will automatically color the background of a cell, according to the button clicked, if I enter 1 of the 6 identifiers.

This is the kind of flow I was thinking:

Button 1=Blue
Button 2=Red
Button 3=Yellow
Button 4=Green
Button 5=NoFill

If Button 1 on, then Buttons 2, 3, and 4 off.
If a cell color already equals 2,3, or 4, then background of new cells change to Blue if it contains "o", "y", "o!", "y!","o#", "y#"


If Button 2 on, then Buttons 1, 3, and 4 off.
If a cell color already equals 1,3, or 4, then background of new cells change to Red if it contains "o", "y", "o!", "y!","o#", "y#"


If Button 3 on, then Buttons 1, 2, and 4 off.
If a cell color already equals 1,2, or 4, then background of new cells change to Yellow if it contains "o", "y", "o!", "y!","o#", "y#"


If Button 4 on, then Buttons 1, 2, and 3 off.
If a cell color already equals 1,2, or 3, then background of new cells change to Green if it contains "o", "y", "o!", "y!","o#", "y#"


If Button 5 on, then Buttons 1, 2, 3, and 4 off.
All conditional formatting is turned off (normal sheet status)

Is this even possible???
Any help would be greatly appreciated. Thanks!

 

[DanteAmor]

Welcome to the board.

Do you want the vba code for 5 buttons or do you want a conditional format on your sheet?

 

[Mooncake]

I can do the buttons without issue. It's the On/Off and Conditional Formatting that's got me confused

 

[DanteAmor]

What is a relation of the buttons with the conditional format?
Do you want conditional format functionality or do you want to put a condition on your button so that it puts a format in the cell?

 

[Mooncake]

For ease of typing, Let "Conditional Format" = CF

The idea is to track, by color, who entered the information. The user, assigned to one of four buttons (each button with a unique conditional format color), would click on the button, enter the data, and IF the data = "o", "y", "o!", "y!","o#", or "y#", then the cell would be would fill with the unique color (according to button assignment).
If Bob clicks on the "Bob" button, CF will be set to his color. If Mary clicks on HER button, Bob's button is turned off, and Mary's CF is set to HER color, and so on...
If you need more information, please feel free to ask. I'm doing my best to be as clear as possible about the parameters. Thanks!

 

[DanteAmor]

I'm not understanding, the cell has two formats, cell format and CF.
What do you want to do to format cell or CF?

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

Explain in your file with examples what you need

 

[Mooncake]

Simply CF.
If Bob enters 1 of 6 codes in a cell, that cell turns HIS color.
If Mary enters 1 of 6 codes in a cell, that cell turns HER color.
ANY OTHER DATA APART FROM THE GIVEN SET WOULD NOT COLOR THE CELL

I don't have enough code to post anything of import. My rudimentary knowledge of VBA would only embarrass me

 

[DanteAmor]

I insist, why the button?
How will the CF know that the data entered in the cell was entered by Bob?


This is how a CF is created, is that what you do manually?

 

[Mooncake]

"How will the CF know that the data entered in the cell was entered by Bob?"

That is the point of the button. To assign a unique color with CF to that user!
When the user clicks the button, it changes CF color to the user's unique color.
I wish to identify WHO entered data by giving a user a unique color that, when data is entered in a cell, I can identify who did it.
The button is for the user to ensure he/she gets credit for data entry.

 

[DanteAmor]

But you do not need a CF for that, you can simply change the color of the cell.