change color

  1. E

    Conditionally Format for cells that do not contain....

    I'm looking to Conditionally Format a cell using a formula for another cell if it does not contain certain letters. Example: I need to conditionally format Cell B1 to be a certain color if Cell A1 does not contain "T","TC","M","MC","B", or "BC". So when I type in anything other than those...
  2. J

    change color event doesn't work in my macro code

    <tbody> 0 down vote favorite i want to make a macro that by any change in cells run automatically, so i write below code for my sheet <code> Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells =...
  3. L

    Impact on Command Button via Cell Value and Check Box Combined

    Hello People, I have to solve this, I know answer can be time consuming but if you have time and nerves your help will be great. so, I have YesBOX ForceBox cell Value 'error' or 'OK' and a button 'execute' Conditions for button when cell value is 'OK' Button stays inactive but color...
  4. C

    Conditional Formatting Based on the Font Color of the Linked Cell

    I have been working really hard to make a spreadsheet super user-friendly for an office manager. The last thing I want to do, I can't seem to find when I Google it. What I have are 2 tabs: INPUT and LOGS. The INPUT tab is for doing just that: input the information and it will populate into the...
  5. K

    Changing Color and Text of a Cell Using a Form

    Hello, This is my first post into this forum. I am trying to follow the rules as best as I can. If I miss any, please let me know. Idea: I set up a range of cells to show a form when they are double clicked. This form gives the user the choice to pick a color and text from a list. When the...
  6. C

    Change cell color by single click

    I want to click on a cell and have the color change. There is a cell range I want this to be in and not the whole work sheet. I have some code which was given to me but doesn't include a range. and I want a different color but having a hard time finding the color codes. If I could have...
  7. M

    Macro Excel Change color based on referenced cell

    I found this place that has a macro button that does something similar to what I want to do. I am able to adjust everything to suite my file perfectly so far except one thing. I am trying to get the color change to be based off of another cell, not a set value...
  8. K

    Change color of current month only...

    Thank you for your help in the past! Step 1: In cell B1, my VBA puts the # of the current month using MONTH(TODAY()). This can change if you know a better way. Step 2: In column B2:B20, there are random 3 letter months B2 = FEB B3 = MAR B4 = AUG B5 = FEB B6 = DEC B7 = JAN B8 = AUG B9 = JAN etc...
  9. N

    Tab Color Choice From Form

    I am using an Excel Form, and trying to make the user choose a color for a new tab they are creating. I am currently forcing an input box to pop up when the user adds a new worksheet. The user inputs a name and a new box will pop up asking the user to select a color. I can get the color box to...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    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 ???
    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
    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
    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
    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
    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