.solid

  1. Z

    Change font color in a text box based on a condition

    Hi, I started recently to learn VBA and I need some help with changing the font color of a value inside a text box based on condition. I tried below macro but it changed the text box color instead of the font. Can anyone help? Sub Set_Color_TextBox()...
  2. D

    Column Chart Colours Based on Horizontal Series Point Name

    I've searched for this, and can't find the right coding to get this to work!! Here is what I have: ChartCol.Select Charts.Add.NAME = "Option Average Scores" ActiveChart.ChartType = xlColumnClustered ActiveChart.Location Where:=xlLocationAsObject, NAME:="Visuals"...
  3. B

    VBA - Colouring chart using conditional formatting

    Hi all, I have inherited some code that is used to colour code segments in a donut chart based on a RAG status, I am trying to amend it to work on a new piece of data however it isnt working. So far it is correctly iterating between each segment however isn't changing the colours. Could...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    • Started by PabloFer
    • Replies: 32
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    • Started by Sleeplol
    • Replies: 24
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    • Started by johnsonk
    • Replies: 22
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    • Started by Dellboy
    • Replies: 26
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    • Started by ipbr21054
    • Replies: 22
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    • Started by Ramballah
    • Replies: 22
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top