cell color

  1. M

    Count Cell Colors

    I have a column of dates and depending on the date, my conditional format will fill the cell with a specific color. I am trying to count the number of cells with a specific color. I've tried the GET.CELL function (although I may be doing it wrong) to try and return the background color value...
  2. I

    Counting cells with colours

    Hello. I need help counting cells that contain colours using a formula. I have data that looks like this: How can I count green cells in both columns B and C and display the total in cell B7? (so it should be 1). How can I count the green or orange cells in column B and put the total in A7...
  3. O

    Double click to change cell to multiple color or back to original

    Below is a piece of code from another thread where double clicking on a cell changes the cell to red. If you double click on the cell again it changes back to its original color format. I am looking to see if there is a way to add additional colors to the choices. For Example, the first double...
  4. K

    display message box when cell color is red

    I have a cell with conditional formatting to turn red when a certain condition is met. is there a VBA code that will display a message box stating duplicate based on a cell color? so what I need is when a cell turns red, a message box to appear showing duplicate. here is the code I have but it...
  5. P

    Search value in array and color if meats conditions

    Hello all! I`m trying to write a macro that goes through all cell in AQ column, splits information in every cell into array and if conditions are met, color the cell. <tbody> # AQ COLUMN 1 line Email Address 2 line Name Surname; Name.Surname@email.com; 3 line Name Surname...
  6. D

    VBA Cell Color Won't stick

    Hello Everyone, I recorded a macro to make specific cells red and the text white. when I run it before saving, it turns red and makes the text white. however, after saving it or sending it to someone, it wont change the format of their cells. Any reason why that would be so...
  7. T

    Conditional Formatting (or an If Then statement?), Highlighting cells based on varying data

    I have one column of names that is fixed, and a list of names that I get on a weekly basis. For example: Varying Names Fixed Names Brandon Steve Lucas Drew Andrew Jordan Jake...
  8. K

    Form Checkbox Automatically Ticks when the color of another cell changes to Green

    Hi! I was hoping someone could help me figure out how to get a form checkbox (open to using ActiveX as well if easier) to automatically tick once the color of another cell changes. So if the color of A1 becomes green (and I can indicate what green exactly or if possible within a range would also...
  9. T

    Change Cell Color Based on Color Index and Value

    Hi all, I could use a hand with this one. I have tested this on a single cell and it works great, however, I want to apply this to an entire sheet. ie Range(A1:BP65). With that said, A1 on the code is set as Today() and the intent is to run the code to determine what cells are passed due. I...
  10. T

    Conditional Formated Cell Color and SUM issues

    Hello, first time poster but long time reader of this forum, it has been a great help! Okay... I have a column of dates and have colored the rows by days of the week using conditional formating based on formula "=WEEKDAY($B9,1)=7" and applies to a range of "=$B$9:$BR$55" Next I want to sum...
  11. M

    Chart - vba to color scatter plot based on cells color

    Hello, I have a macro that will create a scatter plot and then color all the curve to a specific color that I hard code in. I would like more freedom with this and have the macro color the curves based on the cell color that the series name resides in. The example below would plot the...
  12. klynshoe

    Change default font & cell colors for editing

    USING EXCEL 2010 Hello, I have an excel spreadsheet and want to highlight and change the font/cell color of any changes that I make automatically. I will be sitting in a meeting making edits real-time and would like to be able to quickly show the changes without having to edit every cell...
  13. klynshoe

    If (cell color) equals, then...

    Hello, I have some cells under conditional formatting rules to highlight it a certain color. In another worksheet, I want it to pull a particular value if that cell color is highlighted. How would I go about doing this? ~~~~~~~ =if(F5=ORANGE,"",D6) ~~~~~~~ USING EXCEL 2010
  14. Y

    Conditional Formatting based on a different cell

    Hi. I was wondering if there's a formula I could use to format a cell's background color based on the value in a different cell? I have values in cells A2 - A200. I want the cell below the cell directly above it to change a certain color if it's value is greater than or less than the value...
  15. R

    how to turn a cell green depending on another cell value

    I would like to understand how to make a cell (A1) turn green if i was to enter the value 'yes' into another cell (B2). I guess this is really simple and that you would use an 'If statement', however can someone please provide me with a solution. Thanks............FYI - using excel 2007.
  16. V

    change color of a cell for some time based on its value that is not manually entered

    Hi guys, Could someone suggest me a VBA macro to change the color of a cell automatically for a specific period of time -say 5 minutes, based on the value the subject cell holds at that time. The cell value is not manually entered but comes from a sub. There will be hundreds of such cells so...
  17. B

    Lookup cell colour

    Greetings Everybody :) I have a workbook in wich I consolidate 65,535 rows of data from 6 other workbooks using compound lookup. I lookup (using INDEX & MATCH) based on a double criteria. That's not the issue. The issue is that I need to grab not only the values of the matching cells, but also...
  18. R

    Verify RGB against Cell Color

    Hello, I need to verify if a cell has a specific RGB color, for example [204,255,204]. The tricky thing is that I am not allowed to use Macro, VB,... Is there a way to verify it? Theoretically i thought about some ideas: verify the color against another cell (both have the same RGB value)...
  19. 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...
  20. J

    Change linked cell color if value changes

    Basically, I have a workbook with several sheets. Sheet 1 is a "master" sheet and it contains a ton of numeric and text values. The other sheets reference cells from this "master" sheet. This way, a change on the master sheet is reflected in all the other sheets. What I want: When a value on...

Some videos you may like

This Week's Hot Topics

Top