grey

  1. D

    Sum column using NOT equal to criteria

    https://1drv.ms/x/s!AvjBsEPEq12ngUm0YmMHEk1HGIPY?e=npLKjO My data has account numbers and their corresponding $ value Trying to add the $ value for those accounts which are not in the list in Column E I.e. add column B except the items highlighted in grey How best would you go about it? (My...
  2. S

    Almost same product name in two different column

    Hi guys, I am using this string =IFERROR(VLOOKUP(B:B;H:I;2;FALSE);"not found") 1 Example: In column B I have following text: Ipad 6th Generation 32gb Space Grey And somewhere in column H i have following text: iPad 6th gen 32GB Space Grey And the one in column H are deviate a bit from...
  3. H

    VBA - Remove Duplicates + Sort Data

    Hello Friends, Here is the sample data <tbody>#E0E0F0[/URL] "] #FFFFFF[/URL] ]A #FFFFFF[/URL] ]B #FFFFFF[/URL] ]C #FFFFFF[/URL] ]D #FFFFFF[/URL] ]E #FFFFFF[/URL] ]F #FFFFFF[/URL] ]G #FFFFFF[/URL] ]H #FFFFFF[/URL] ]I #FFFFFF[/URL] ]J #FFFFFF[/URL] "] #E0E0F0[/URL] "]#FFFFFF[/URL]...
  4. N

    Suddenly Slicer button and Form Control on Worksheet is grey out (could not use)

    In my workbook after applying update on 3rd August 2019 ,in one particular workbook Slicer and Form controls are disable (grey out) and I could not use. I am using a workbook in MSExcel 2016 and I have saved the file in *.xlsx format. I tried to figure out every thing by checking in 'Trust...
  5. R

    VBA for Auto Populating with Fixed Values & Shading

    Hello, Can you help me with a macro please? I need to auto populate certain cells in different rows with "N/A" and grey shading depending on selections made in column B from a dropdown list. For example, if we select "School" in cell B19, then E19 to P19 show "N/A" with grey fill colour and...
  6. M

    find and list top 10 items in a table showing their row and column labels?

    I have a table which summarises the number of sales of tshirts of each colour combination (its actually much bigger than this) I'd like to show a list of the top 10 most popular colour combos so somehow i have to find the highest 10 values from these cells and display a list of them, in order...
  7. A

    Shade visible rows only - when value in column changes

    Hi All I have a sheet with a lot of data, and a macro set on a button which hides any rows where the colour is shaded dark grey in a particular column. I want to put on shading when the value in column A changes (like banding in a table),but only when the value changes and the rows are...
  8. T

    Search content in another cell as word, not sentence.

    Hi, I am working on formula to help my staff on their data entry. We have the primary code in column A and we need to input color of each item in column B In column C, we then have this formula, =IF(A2<>A1,B2,IF(ISNUMBER(SEARCH(B2,C1)),C1,C1&","&B2)) it basically check if all these 3 input...
  9. MFish

    Unique IDs to change conditional format

    Hi, I'd like to setup a conditional format that will change accordingly to certain Unique ID's. <tbody> OAK 1 OAK 1 OAK 2 OAK 3 OAK 3 OAK 4 OAK 5 OAK 5 </tbody> The conditional format I'd like to run will highlight the cell range A1:D1 when the unique ID is found...
  10. M

    Conditional Formatting

    Hello, I have a spreadsheet with two columns, one has an area name in and the second column has the branch name. Some areas could have 5 branches and some could have 15 branches. I would like to format each row based on the area name. So if its area 1 then say a light grey, if area 2 then a...
  11. A

    Formula for conditional formating - NOT AS EASY AS IT SEEMS

    Hi all, Wondering if someone could help me with a problem. I need a formula do add to conditional formating to auto turn grey lines depending on day change and acording to the table below? <tbody> 01-01-2019 MONDAY 01-01-2019<strike></strike> <strike></strike>MONDAY<strike></strike>...
  12. T

    Macro to change background colurs between two greys but over mutilple lines

    Hi Everyone, I need a macro not conditional formation for this please. I have a range of data in sheet "Cals" Range S11:BX and lastrow. Now Column S holds the clients name and all clients are sorted to be together. what I need is a macro that can give me two Greys (pref with RGB numbers so I...
  13. M

    Color code duplicates with a twist

    I know color code duplicates is a very common issue here on the internet, but I can't find any solution which is similar to my needs. Based on the value in column A("My data") I want to color code the whole row where the value is the same. I.e. row 1 and 2 has the same value and should be...
  14. L

    error when executing multiple checkboxes to run macros for printing

    Hello all, I'm not terribly experienced in macros, but I'm learning as I go. Any help is appreciated. I have a workbook with many worksheets inside it. From a master worksheet, I'd like my staff to be able to select which worksheets to print by selecting them with checkboxes. I have a macro...
  15. K

    Sorting Data across multiple columns

    Evening, I have a report that is produced from a front end system where names are entered with a comma separating them, some have 1 name, some 2 names some 3 or 4 for example: Jo Blogs, John Smith Shaun Green Betty Jones, Sharon Blue, Harry Grey Is there an easy way to separate the names...
  16. S

    Countif and countcolor

    Hi I am currently trying to create a formula to count the number of cells of a certain colour that is a certain criteria. I'm looking for something like a countcolorif function but can't work it out and I'm getting frustrated that I can't work this out! Basic version below of spreadsheet...
  17. E

    Is it possible to create a graph of variable set of cells?

    Hello! I want to make a graph that one of the lines is formed of the data of a range of cells. However, this range of cells may change with updates. For example, I would like the line to be formed from the GREY cells of a line, so that when I grey more cells, the line will update. Is that...
  18. A

    VBA shape SpecialEffect and/or BorderColor properties?

    On my userform, I have a textbox (uf1vb1_OPS) that has code written to it when clicked by the user executes code which. I wish to mimic as a button. By default, the shape's SPECIALEFFECT property is Raised (1- frmSpecialEffectRaised). When the user clicks the shape, I want the button to appear...
  19. D

    Conditional Formatting

    Is it possible to create custom bands in a table? For example, I have a few hundred rows of content and the first column is an identifier that looks like this: ClientA-48102-1 ClientB-51556-1 ClientB-51556-2 ClientB-51556-3 ClientB-59900-1 ClientB-59900-2 ClientC-40938-1 ClientC-40938-2...
  20. S

    SUM and Contains Formula

    Hi, Newbie need some help, <tbody> EXTRAS Colour <colgroup><col></colgroup><tbody> 2x25002770, 1xPAD, 1xWindow, 2xInso </tbody> <tbody> Slate Grey </tbody> 1x25005100, 1x25002770, 1xPAD, 1xMotor, 1xWindow <tbody> Mountain Blue </tbody> <tbody> 2x46004100, 2xMotor...

Some videos you may like

This Week's Hot Topics

Top