cell color

  1. S

    VBA search tool to return data and cell color

    Hello, This is my first post so please go easy on me!! I have an excel file that allows me to enter in data in 2 cells and return any matching values, it works great but when it returns the data it is not returning the cell color. So when a cell matches it should bring back the content and...
  2. H

    Formatting cells with variable values

    Hello there I would like to find a VBA to format the cells ($A:$B), based on the values in $C and $D, which are variable, with the result in columns $E and $F, as per the below sample: Source Delays Desired Font Desired Color Result 1 Result 2 John Doe 1 45 BOLD #C00000 John Doe 1 45...
  3. J

    Excel/VBA - Fill color of a cell in pivot table according to column value in source table

    Hello! I want to make a pivot table to control clients' payments. This pivot table has as source a table in another sheet, like this (I made a simpler table just to use as example): I want the pivot table to have these elements: Row1 - Client Row2 - Type of income Column - Month Values -...
  4. S

    Function Not Working with Conditional Formatting

    Hi; Made a function which checks if the cell color is red or yellow and returns the word or returns nothing"". The sheet with the function looks into another workbook with conditional formatting which turns the cell into three/four colors dependent on the cell input. My issue is that the...
  5. J

    Checkbox Conditional Formatting Referencing with Cell Color Counting Problem (Multiple Worksheets)

    Hi, So I am in the process of creating a spreadsheet for a business venture and I am using the spreadsheet as an internal worksheet for services that we provide. On worksheet 1 I have an extensive list of services we provide. Each service is connected to a checkbox. Worksheet 2 is our service...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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
  19. 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...
  20. 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.

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top