white

I have an excel sheet that I have the fill color change and then sort it with the colors divided. I want to have the cells that are red when they have a value of 0 to fill to white which I have set up. I then want the rows that have now been filled white to sort back into the upper rows in the...

Hi, I have code with INCLUDEPICTURE and problem is that if no picture is found I have to place white pixel image to avoid X. Is there any way to have Section Break or something like {QUOTE 12} in code instead white pixel image? Thanks in advance, code is from macropods page Word Mailmerge Tips...

Hi, Can anyone help me on the Data validation based on the cell value. Actual data table as follows; <tbody> 325XX Apple Orange Mango 326XX Black White Blue 327XX Car Bike Bus 328XX Laptop Wifi Mouse 329XX India America England </tbody> Data validation...

Hi All, long time reader first time posting I have read a few other threads regarding similar issues to what lm experiencing but nothing is solving my issue though. I have a spread sheet that l have just created from a blank brand new spread sheet. Its set on a landscape A4 size piece of paper...

Hello, I am looking VBA solution for specific task look up in row constant occurrences Data got in cells C5:P22, "1" is filled with red colour and white fonts, "X" is filled with dark green colour and white fonts, "2" is filled with blue colour and white fonts, Results shown in R6 AF22...

Hello there :- I have a list in A B and C. Let's call this array ArrayOld I have another list in F G and H. Let's call this ArrayNew In ArrayNew, I can have data that are not in ArrayOld. I would like to update the data in ABC with the ones in FBH. But beware of new data... All cells are...

I've reduced both to 0% gap...yet, the bars still show a slight white sapce between them...theyre not touching....someone please help!

Hello i'm trying to group the CODE values and get a total of the count based on certain instances. i cant use a pivot table when doing this so VBA code is preferred Then i would like to do the same but for "Coconut" only in the FRUIT2 Column using certain instances Then i would like to know...

There is something simple that I am missing here, but can't take any more time googling it Applied conditional formatting to Column I to change font color to white when Adjacent Cell in Column H has no value. H contains a formula. Conditional formatting formula is =$H2=" " Here is what...

To be honest, I don't even know how to explain this fully in words, hoping the table will illustrate the dilemma. I have a data validation list in column F, with the appropriate selection made in cell E2 e.g. "white" in table 1. Table 1 <colgroup><col style="width...

I thought I had a good idea, but I am not so sure now. I am trying to use the same concept for in-cell charts using the REPT() to make a Gantt chart. The problem I am running into is that I can't get a bar to cross cell boundaries without some white space, so it looks clunky. I have used...

I need to count not only by item no but also color. In the following example, the desired result is in blue. Row 5 and 6 have the same item number and color. Thus, the sum is 22 (16+6). The closest thing I can get is with the following formula, whose result is in the last column. It seems I need...

Hi, I've been scratching my head all day on this one. I feel like it should be easy but I can't fathom out how to do it. Any help would be much appreciated So here's a sample: <tbody> Item Colour Colour Lookup OFF WHITE WHITE DARK BLUE BLUE GREY MARL GREY NAVY/RED/GREY MULTI...

Hi i was given an Excel template by somebody to use and when i look closely, near the top of the page there is some white item/spot. I cannot click on it until i zoomed the page to the max, and when i finally clicked it, it showed white box with absolutely nothing to click at. (picture attached)...

Hi, I have a UserForm with a command button that, when pressed, causes page 1 and 2 of any worksheet named with a 5-digit number (eg: 76349) to be printed. For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then ws.PageSetup.Orientation = xlLandscape...

Hi everyone, I'm new to using VBA and am in need of some practice. My manager often asks me to deliver data sheets in excel with all visible cells except the ones with data in them whited out as he thinks this looks better. I tried to write a code to do this for me but this turns all of the...

Hi, I'm using VBA to copy the format of a cell from one workbook to another. Here is the code: Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False When I paste with this code it works perfectly fine on my workstation using both...

Hello, I want to determine if certain cells are filled or not filled. I also need to assign a white fill to another cell based on if the cell is white or not filled. I have: ElseIf Sheets(n).Cells(b, 7).Interior.ColorIndex = 2 Or 0 Then With Sheets("Results_STEEL").Cells(r, c)...

I frequenly have two Excel spreadsheets open so I can copy and paste data between them. For some reason, when I alt-tab between the spreadsheets, sometimes a portion of the spreadsheet is pure white... almost as if that part of the spreadsheet hasn't "refreshed" yet. If I minimize it and then...