color cells

  1. undemane

    Draw line chart based on cell color

    In Cell A1, A2, A3, A4, etc, I have test data that is colored Yellow, Blue, etc. In Cell b1, b2, b3, b4, etc., I have the values I want charted as a line chart. But, I want to chart to pick up data in col. B for cells that are colored yellow in Col. A. Without writing any VB Code, is there a...
  2. K

    Highlight cells

    Originally Posted by kamranyd View Post Code: Attn_Name = .Range("B13") If Len(Attn_Name) = 0 Then MsgBox "Please enter receiver name", vbCritical, "Quotation Receiver Name Error" Range("B13").Activate ActiveWindow.ScrollRow = 13 Exit Sub End If...
  3. N

    VBA to pull out all colored cells from a row to a different sheet

    Good morning. I will try and explain this as thoroughly as possible. I have a sheet with Dates as rows and test locations as columns (just fyi...there are about 275 columns of testing points). It is conditionally formatted so anything out of control gets highlighted in red as seen on 6/5. Please...
  4. C

    Subscript Out of Range Error Identifying Duplicates Using Color Scale

    This code seems to work great in identifying duplicates within a column; uses colors to group 'like' dups - but is throwing the Subscript Out of Range Error 1/2 way through it's identification process (when it's running on a longer list) -- short lists - it doesn't throw the error. I found it...
  5. S

    Insert New Row VBA Macro

    Hello I am trying to insert a new sheet row using VBA and then change the Interior.ColorIndex of specific cells in the new row. I am using ActiveCell.Offset(1).EntireRow.Insert to insert a new row below the active cell, but I am unsure how to change the background color of specific cells in...
  6. E

    Mark cells in color pending on correct/incorrect values

    The code is getting to blurry for a yellow belt exceller as myself. I keep getting wrong values and #####...:confused: Basically I am trying to make the cells in the column ”level” to mark the cell green when the user for example puts in the correct level value (if it matches the value in the...
  7. F

    Copy whole worksheet with keep COLOR format

    Hi, I tried to copy selected worksheet to new WorkBook. But during the operation CELLs/COLUMN/ROW COLOR have been changed :/ For Each ws In wb.Sheets next_ws = ws.Name If dict_sheet.exists(next_ws) Then If next_ws = "Sam" Then Set NewBook...
  8. N

    How to modify custom Function?? Help.

    Hi all: I have a custom function that count a range of cells by a specific color that works great, but i need to modify it, so it doesn't count more than one cell in a row.:confused: This is the code: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)' This...
  9. C

    Provide color choices for columns or cells on page

    I am developing a scheduling board for public viewing in my factory. I want to be able to quickly change colors of a single cell or a column from available colors on the page. I want to hide the command bar. How do I program clickable cells or buttons to choose a color?
  10. R

    Need help referencing highlighted cells in a dataset

    <tbody> 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 6 9 6 9 17 3 1 1 2 1 1 </tbody> :help::banghead: =INDIRECT(ADDRESS(1,MATCH(1000,B2:V2)+1)) I have a dataset with over a 1000 rows.:eeek: I just pulled one row in my...
  11. N

    Chaning Cell Colors within a Function No Conditional Format

    Hello, I am trying to make a scheduling spreadsheet that can give visuals and allow for a lot of variable change. I am needing some input on how to change the color of a cell. I don't want to use conditional formatting, because every time I add a new project, I will have to add the formatting...
  12. T

    Macro to Color Cells on Multiple Sheets

    I have a workbook with some summary statistics on one sheet for a couple different sales regions. There are about seven other sheets with other data on them for the same regions. I want to keep formatting consistent across each of the sheets for each of the different regions. I was hoping I...
  13. M

    Code to return color index of a referenced cell in the following cell

    Hi, I need a code, which would enable me to return the color index of a colored cell (colored via conditional formatting). If there is a colored reference cell, return the respective color index in next cell. I use Excel 2007. I need it only for four colors – red, blue, yellow and green. If the...
  14. andrewb90

    Coloring cells based on text in another cell.

    So I have cell 'A3' that may have a variety of words or phrases typed into it. if the term 'unused' appears I want cells B3:D3 to have a background color filled in. I think this is probably really simple and I am just missing it. Thanks, Andrew
  15. P

    Counting Cells and color coding

    <TABLE style="WIDTH: 352pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=469 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR...
  16. H

    Formula for counting coloured cells.

    I have a table of numbers with conditional formating, formula's are... =COUNTIF(OFFSET($W3:$AB3,1,0),W3+1)+COUNTIF(OFFSET($W3:$AB3,1,0),W3-1) - color, lemon. =COUNTIF(OFFSET($W3:$AB3,-1,0),W3+1)+COUNTIF(OFFSET($W3:$AB3,-1,0),W3-1) - color, light blue. Column AC, I want to count the number of...

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