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!
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!