white

Hi I have a column like the one below. I highlighted the cells and then dragged the autofill down. I got all cells value as = "red". Why is that? is it because they are color words. Thank you so much. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> red black...

Hi mrexcel forum. I registered here by googling only to solve my problem. If this problem is solve than my task would be much much easier. I have data on two column till 600 rows. first 300 is grayed and 2nd 300 is white. I want some kind of conditional formatting or filter or rule or anything...

So I have this code that works to add rows to a table. Sub insert_rows() Dim x As Integer x = Application.InputBox("Number of Rows", "Number of Rows", Type:=1) Range("A" & Rows.Count).End(xlUp).Select Range(ActiveCell, ActiveCell.Offset(x - 1, 0)).EntireRow.Insert Shift:=xlDown End Sub If...

<tbody> A B C D 1 United Red 2 United 3 City Blue 4 United 5 City 6 Spurs White 7 Spurs </tbody> Hiya How do I get Col B to cells to populate with "Red" if the cell in Col A is 'United'? Likewise City in B5 should populate as "Blue"; and...

i have a string that has produced duplicate words AC2 >"test grey grey white black white" what i want to produce> "test grey white black" AC3> "blue green green black white black" what i want to produce> "blue green black white" is there a way in VBA to remove duplicate words out of a...

I have a set of data on one tab of an Excel workbook. On another tab (or ideally in another workbook) I would like to produce a list of records that match a certain criterion. Here is a generic example. On the Raw Data tab I have raw records like this (imagine two columns - one with a color and...

if i have a string "bob has white trousers" i want the formula to search multiple colours and return the value white. so my formula would contain something like SEARCH( "black", "white", "grey", "green", "blue") etc If it had multiple values i would want to just accept the first. I cant get my...

I'm trying to find a way to change the background colour of textboxes on a userform to assist users who have dyslexia. I thought it might be as simple as setting their preferred colour on installation of the file, then calling that colour each time the form is loaded, but it doesn't work. This...

Hello. I have multiple rows of data that I would like to consolidate into one row based on information in a number of columns. In the example 1 below I would like to consolidate all rows based on UniqueId, however would like the rows for Product & Question columns combined across the page with...

Hi all, Posted here on thread https://www.mrexcel.com/forum/excel-questions/1078016-what-am-i-missing-again.html and got to the bottom of that problem. Solved it by using the Round() function. Now my sheet and not even the affected rows does not show values > than a cell value as yellow...

In column A I have a data which are filled color with white and red. I want to show the cell with white color only in column B. Any suggestion?

I have the 6 columns that I need to include in an IF formula that I am having issues with. Column A is Ethnicity,Values are "Y" for Yes and "N" for No Column B is America Indian, Values are "0" mean not American Indian and "1" meaning person is America Indian Column C is Asia, Values are "0"...

Hello friends, I searched the internet, but I only got to the "design" menu in an artwork that could stain my rows in one, such as gray, white, gray, white etc or in the options offered. I'm looking, I'm probably going to a macro - for a way that in column A2:J by the end of the table I...

Morning, I have a list in the form of a table. I noticed that say the first 12 cells are blue white blue white etc etc but then after that all the other cells are white. Can you explain why this is & what should i need to do if anything. Thanks

Hello, I have a dynamic list in column A which contains various names, and multiple instances of the value FALSE. I would like another list in column B, which has the same values, but without the FALSE values. For example: Blue Yellow Green FALSE Turqoise FALSE FALSE Black FALSE White Would...

<colgroup><col><col><col><col><col></colgroup><tbody> Posting Date Document G/L Acct/BP Name Inventory UoM Qty FG00017 500 Litre Water Tank White 02.08.18 SI 2109 Finished Goods Pcs 14 02.08.18 SI 2109 Finished Goods Pcs 13 02.08.18 SI 2111 Finished Goods Pcs 11 02.08.18 SI 2111...

Hi, I have an Excel report, 7 Tabs, 1 for each day of the week. 4 Separate sites fill out this report each morning. All shortages are entered into the table, whichever site opens the report first, second, 3rd or 4th (This will vary from day to day) File is not shared I purposely refrained...

I am trying to group some rows. When I group I don't see the plus or minus area I just see a white line. See the attached pick. I have checked the Show outline symbols if an outline is applied and I still see the white line to the left. See image. Thanks I can't seem to add a pick.

I have a conditional formatting formula changing the color of every other line to a light gray using this formula: =MOD(ROW(),2)=0. The other lines are typical white. So, is it possible for every other line that is gray to have a specific word, in this case, "VACANT" with the formatting of...

I have a list of options <tbody> productA color red productA color white productA size s productA size m productA size l productA color blue productA color white </tbody> is there a way to use these existing date to populate/create a row in such way that it would be <tbody> A...