1. A

    VBA Highlight duplicate ID which sum of their value equal zero

    Dear Community I need a formula that highlight values which total is zero but have the same reference ID I want to have the below results. <colgroup><col span="2"><col></colgroup><tbody> ID Value Result A 1 highlighted on color green A 2 A -1 highlighted on color green C 4 C -2...
  2. A

    I want the code to get pictures link from this source code page by using VBA. Thank you.

    <tbody> <dt class="p-item-title">Color:</dt> <dd class="p-item-main"></dd> :blank"...
  3. L

    ActiveX Checkbox - Hide rows based on color

    Is there VBA code to hide all rows that are a certain color if a checkbox is checked? Here is a screengrab of what I am working with - I want to be able to uncheck the checkbox next to "A" in B1 and have all of the yellow rows get hidden. I used a simple code to get...
  4. B

    Count unique values based on criteria from other column

    Hi I have a sheet that looks like this color | number now i want to count how many unique numbers i have of one color So the values can be like this in color column blue red yellow blue blue yellow red yellow yellow in the number column 123 22 123 143 12 132 123 22 22 22 So how many...
  5. E

    Group values based on two different column values

    Hello Gurus, For the following issue, I request your assistance. I have two columns: first one has Shirt color and second one has Sizes. Within a color, the order size received is varied, just as below <tbody> Shirt Color Size Yellow XL Yellow XL Yellow XL Yellow XL Yellow L...
  6. N

    Return the fill color after save

    Hi, I have this code (below) that remove the fill color after update those 5 cells. I need that when I save the worksheet, those 5 cells return with the fill color. Is this possible? Code: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target...
  7. N

    Remove fill color when update cell

    I have a cell with drop down list which has a yellow fill color. Is there a way that the yellow fill color will be removed when I update this cell? Thanks in advance
  8. ExcelNovice

    cell color based on value in other cell

    I need a macro to change the color of a cell based on the value in another cell. I have data in range C4:L4. The user will review the content of the cells in the range, and may enter the letter Y or the letter N in C5 or D5 or E5 and so on. If Y is entered in C5 I want the cell color for C4 to...
  9. J

    VBA to change background color of cell. color based on day of the month

    I have current code to change the background of the cell I updated "Today" to the color of the day. Today is the 15th of the month, so todays color is 15. What I am looking for is the "15" to change based on the day, so tomorrow the code would change to 16 without me going into the code daily...
  10. E

    Automatically Change Row Color Based on Cell Input

    I am looking for a way to automatically change the color of a row based on the content in a specific cell. For example: - the default color of any row is white - if content is added to cell A2, the color changes to red - if content is added to cell B2, the color changes to green - if content is...
  11. A

    Macro to bold, highlight & change font color of certain cells in a column

    MACRO TO BOLD, HIGHLIGHT & CHANGE FONT COLOR OF CERTAIN CELLS IN A COLUMN I’m embarrassed to say how long I’ve been searching for an answer to the following problem: The last column(“H”) on my spreadsheet contains the numeric totals of expenses in each row. There are also spaces between some...
  12. P

    Conditional Formatting - To color following Mon as Public Holiday if Public Holiday falls on Sun

    Hi, I have a workbook with 3 worksheets - 1st worksheet shows a yearly calendar, 2nd worksheet shows a list of course schedule, i.e. course name, course duration, start and end date, 3rd worksheet shows Public Holiday of that year. Help needed to set a rule using conditional formatting to...
  13. K

    Pivot Chart Color Theme Customization Possible?

    Hey All, Just a quick question I cannot find an article or answer to. I have a table of data represented in pivot tables/charts. It covers several call center metrics in a line graph format (Calls Offered, Calls Answered, Calls Abandoned). I want to set a monochromatic color scheme / year...
  14. S

    powerpoint table to have color scales similar to excel

    In excel under conditional formatting, there is a color scale option where if I highlight a table and choose a color scale, Excel will automatically highlight my cells with different shades of green, yellow and red, depending on my value. I have a VBA code that currently copies each value in my...
  15. C

    Conditional formatting for 1 alpha followed by 6 numeric characters

    I am trying to implement conditional formatting in a column so that if the first character is alpha in the range A through Z, or a through z, the fill color is green, if not the fill color is red. I started with =OR(LEFT(S2,1)="A"),(LEFT(S2,1)="B") etc with the fill color set to Green, then the...
  16. T

    SUM last N values based in criteria

    Hi guys, Does anyone could help me? What I need is to type a color and the last N values to be calculated. N values = 1*4 = last 4 values So, if I enter 1, it needs to get the last 4 2 = 8 3 = 12 and so on... Sometimes a color has 5 cells but the fifth is always marked with an X and it is...
  17. J

    VBA Macro for Identifying Background Color

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545; min-height: 14.0px}</style>I am reaching out to you guys because I have no experience with VBA but I...
  18. A

    Highlight Selected Active Cell

    I am using Windows 10, Microsoft Office 365 (2016). I have written macros in older versions of Excel and had no trouble, but now I am stumped! I need help creating a macro that will change the active cell in Excel to a different color - RGB (R204,G102,B255) which is in the purple color range. I...
  19. E

    Last Color

    Please how can I make Excel remembering last color I used, so I dont have to select the color each time? Thanks
  20. D

    Extract multiple data from cells in a range based on cell color

    i want to take the data in the range C12:K20 and extract only the green colored cells into a list under A1.

Some videos you may like

This Week's Hot Topics