grey

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...

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...

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]...

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...

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...

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...

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...

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...

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...

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...

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>...

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...

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...

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...

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...

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...

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...

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...

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...

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...