cell color change

  1. J

    Worksheets copied into new workbook - Cell Color/Fill Changes - Unintentional - Preserve Cell Color/Fill

    Hello, I am using the following code (which works great) to export the sheets named "Labor BOE xxxx" after my spreadsheet creates multiple copies of a template worksheet, inserts summary tables, and populates the summary tables. The one issue that I haven't been able to figure out is... after...
  2. A

    How to change the color of cells with a cell value change in worksheet_change

    Hi I am working on a code in which i have to change the color of certain cells if the value of a cell is Y/N. The color should change with the user input. Set wsheet = wbook.Worksheets("XYZ") For Row_start=10 to Row_count 'Row count is the last used row in the worksheet RowValue =...
  3. A

    How to change the color of cells with a cell value change in worsheet_change

    Hi I am working on a code in which i have to change the color of certain cells if the value of a cell is Y/N. The color should change with the user input. Set wsheet = wbook.Worksheets("XYZ") For Row_start=10 to Row_count 'Row count is the last used row in the worksheet RowValue =...
  4. R

    Conditional Formatting/VBA/User Defined Function for Cell Color

    I have a spreadsheet that has conditional formatting where I track insurance expiration dates. If the cell is blank it is yellow If the date in the cell is current it is blank If the date in the cell expires within 30 days it is orange If the date in the cell is expired now it is red Now...
  5. D

    VBA Cell Coloring - Not Conditional Formatting

    Hi all, let's see who can help me with this next excel vba question: I have a list that consists of several names (text or number strings - representing names and codes, usually 1-20 different strings), some repeating only once, and some several times. I'd like to sort by name (easy) and to...
  6. D

    changing cell color depending on value

    how can i say if A1 is more than 100 then make the cell color red. and if A1 is less than 0 then make the cell color green. Also can i make A1 turn red only if A2 is more than 100 AND A3 is between 80 and 100? Help is much appreciated
  7. K

    Color change of cell if value is higher than specified cell to 130%

    Hi experts, Wondering if someone know how to Highlight a cell if value is >130% from another cell e.g. if cell B10 is greater than C10 by 130% (or custom % value) requred is if value in C10 = 10 and B10 = 13 then B10 should turn green if 15 yellow and if >18 red regards,
  8. K

    Cell color change automatically on entering value

    Hello there, It may sound silly but in my ciecumstances it will ease my work. If I enter a value in certain cell A2 to CK2 the color of cell may turn to Red as it would be alert activity. Experts know well how to do it.:rolleyes: regards,
  9. D

    Color more than one cell on the same row when a cell has a certain numeric value

    A B C D 1 Name 2009 2010 Total 2 Sam 400 600 1000 3 John 200 400 600 4 Eric 100 300 400 I'm working on a simple list, see example above, where a cells background color changes (in a simple traffic light system) in both the Total (column D) and Name (column A) when the...
  10. M

    Cell color change when value is found in Range

    I have a annual meeting calender. In this calender different meetings are booked in different colors. (eg. sales, marketing, HR, Finance) For every department meeting is booked in every month. To view only one meeting at a time on click a have this formula. This formula works fine but it...
  11. jlhudg23

    Stop cells from automatically shading

    Problem: I have a few contiguous cells (below each other in same column) that are shaded (fill color). When I enter text/data/whatever in the next cell down and hit [ENTER], the cell I just entered text/data/whatever into automatically shades to the same color as the few cells above. I want to...
  12. C

    Spontaneous Cell Colour and Font Size Changes

    A colleague of mine has an Excel file where the font sizes and background cell colours of individual cells sometimes appear to have changed spontaneously when she re-opens the document. She had formatted the columns to different colours to indicate what they were being used for (various types...
  13. andrewb90

    Conditional formatting problem

    I have a list of food products on several sheets. In one column are all of the expiration dates. I have conditional formatting to change the cell color to a different color depending on if its expiring this month, next week, this week, or in the last 7 days. Now after a product has been expired...
  14. S

    Cell Color change with data input & print based on cell color

    I currently have a macro that prints all visible (unhidden) sheets. Sub Button1_Click() Dim ws As Worksheet For Each ws In ThisWorkBook.Worksheets If ws.Visible=xlSheetVisible Then ws.PrintOut Next ws End Sub I want to have certain required fields be colored with a certain color. If...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top