Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

adjust button to shown colors 3N

29232655 (3).xlsb


1- need adjust the "CONSECUTIVE PAIRS " button  at  first color all the consecutive pairs and trig when all are show


then after the click


2- show the consecutive and trig only 


as shown :


then at first with all pairs 



Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Try this.
29233184.xlsb
ADRIANA P

ASKER
is not working!!
ADRIANA P

ASKER
need the color for consecutive pairs 
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ADRIANA P

ASKER
color all the consecutive pairs and trig
Martin Liss

Please show me where it is not doing that.
ADRIANA P

ASKER
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
in columns AG AH AI (ALL the way )
Martin Liss

I didn't work correctly in the workbook you attached either.
ADRIANA P

ASKER
Best Expert you lead the way!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Best Expert !!!

the color is not showing up for the consecutive pairs  

why?

Martin Liss

Whenever there is a problem you must know that you should show or tell me where. Why don't you automatically do that?
Siempre que haya un problema debes saber que debes mostrar o decirme donde. ¿Por qué no haces eso automáticamente?
ADRIANA P

ASKER
ok

in columns AG AH AI i need to see the color for consecutive pairs

as I have shown in the pic  and in the upload file
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Please Best Expert !!i as i shown in this pic

Martin Liss

in columns AG AH AI i need to see the color for consecutive pairs
Of course I know that! Please show me a cell in the 29233184a.xlsb workbook that has a consecutive pair that isn't colored correctly.
Martin Liss

OK I see the new picture Give me a minute.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Martin Liss

Are you using the 29233184a.xlsb workbook? I ask because this is what I see in that workbook.
ADRIANA P

ASKER
ok, I see you Right! 
ADRIANA P

ASKER
you lead the way!

 Best Expert  
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.