-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
#colorcell
-
Y
Color cells according to its nature
Dear all, Happy to join mrexcel ! I have an brain teaser with VBA. I want to create a macro that will color: - Hard coded cells in blue police. - Formula (ex: vlookup): In black police. - Linked cells (ex: =Sheet1!$B$5): In green police. Do you have a code that could work out ...- YZ1675
- Thread
- #colorcell #conditional formatting #excel #formula
- Replies: 4
- Forum: Excel Questions
-
A
Excel color retrive with drop down list
Hi i created an excel file with Cyprus League teams. I made a drop down list with these teams in a sheet named teams. i colored each team with its official color. i have a separate sheet named rounds. when i select two teams for example it does not come with the color as created.any idea of...- Antrew80
- Thread
- #colorcell #dropdown #excel
- Replies: 7
- Forum: Excel Questions
-
F
How do I write a Macro in Excel for colored cells based off Criteria
Im not good with macros at all and I need help. For the Green cell, I want it to turn green if the number is <+-10% For the Red Cell, I want it to turn green if the number is greater than >+-10% TO calculate the percentages at the bottom, follow this formula, SlopeX50° / D$6-D$7 D6= 0.00035...- fordintern
- Thread
- #colorcell #excel #macro
- Replies: 1
- Forum: Excel Questions
