blue

I have some text and digit in A1 to J1, but i want that if i type "O.K." in K1 then all line A1 to J1 changed to Blue Color.

Hello, (I did search for a solution on here but couldn't find, hence the new thread) I have the following issue if anybody can help: (Many to many relationships) List 1 <tbody> Ref Property 1 Property 2 0.1 A E 0.2 B A 0.3 C D 0.4 D B </tbody> List 2 <tbody> Properties...

Hi excel experts! I'm trying to use sumifs that contains multiple columns...So I want to get the value highlighted in red if Color1, Color2, and Color3 contains "red", based on its assigned values. I was trying SUMIFS and SUMPRODUCT, but couldn't really figure it out. <tbody> code (columnA)...

i've been playing with this all morning but no progress. Any suggestions would be helpful. I'm reading in a xls file looking at column I. When I find multiple entries in col "I" separated by a comma, i need to create a new row for each Item I find and insert it into a new row. Right now I have...

Hello, I have two tabs. [TAB1] is where I want to place my results. I want the results starting in columns C and moving right, as many columns as need be. I am hoping I can limit the columns the results section will be by only returning unique results (i.e. if there are three reference IDs...

Hello, I have 5 columns, all of them can contain specific word 6th column is numbers. Is it possible to take all 5 columns, find if cells contain specific word and sum the number if it does. For example here I want to sum numbers of red only : <tbody> red blue yellow 5 blue red yellow...

Hi, I have several columns. Each column needs to highlight certain times in a certain color. For each column the time and color is different. Column A 9:00 (color Blue) Column B 5:00 (color Green) Column B 6:00 (color Yellow) Column C 8:00 (color Red) Column C 9:00 (color Light Blue) etc...

I have a small data that of matches played between two teams. The data looks similar to this. <tbody> Matches data1 data2 data3 Yellow Oak vs Blue Stone Yellow Oak vs Green Grass Oak Blue Stone vs Green Grass Oak </tbody> <tbody> Teams Match Played Yellow Oak Blue Stone...

Hi Team, Is there a way to shorten this code used in if condition. If Sheet1.Cells(i, 1).Value = "Green" Or Sheet1.Cells(i, 1).Value = "Red" Or Sheet1.Cells(i, 1).Value = "Blue" Then like If Sheet1.Cells(i, 1).Value = Array("Green", "Red", "Blue") Then Thanks in advance Regards, mg

Hi On Sheet1 I have the following pieces of data: <tbody> A B C 1 Date Number Colour 2 13/09/2019 123 blue,green 3 13/09/2019 456 green,red 4 13/09/2019 789 red 5 14/09/2019 123 green 6 14/09/2019 456 red,blue 7 14/09/2019 789 red,green 8 15/09/2019 123 blue,red 9...

Hi I have 2 sheets in a workbook. The first sheet ‘kit list’ has a table with a drop down boxin B12 to B210, so I can select a product from the drop down, then in C12 to C210,I can put the number of each of the products I want. There could be multiplevalues that are the same in column B...

Is there a formula to count all cells but omit ones with certain text? for example: I want to count all of the cells below but I do not want to count the ones containing the word "Blue" Yellow Red Blue Green Yellow Red Purple the result would be: 6 Help with this would be greatly...

<tbody> Hello All, Here is the sample strings in (A2:A11) result(B2:B11) Lorem ipsum dolor sit amet, amber amber consectetur beige adipiscing elit. amber|beige Nunc azure dictum black odio light blue quis nunc imperdiet viverra. black|light blue|blue Sed at beige beige beige amber...

So i have a dictionary of colors some vendors like to write in all caps, some like to write in proper, some like to write in lowercase, some have their own thing goin on? anyways my statement here ary2(i, 4) = dicFINISH.Item(ary2(i, 4)) takes their color description and replaces it with a...

Hi: I have data in col A and B. I'd like to build a macro that, if it finds the term "trigger" in col A, it copies the data in col B to col C (all in the same row). But, if it doesn't find the term "trigger" in col A, it copies the prior successful data to col C. Here's what I have so far ...

Hello, I am looking for a specific countif formula. Basically in column E I have names of locations: E Blue Red Blue Green In Cell H10 I have the word "Blue" In Cell H9 I want a formula to look in Column E, find how many match Cell H10 and return the number, in the above case: 2 I thought...

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

I have a list of unique items (RED, BLUE, YELLOW, GREEN) & I have an INPUT cell (B1) to specify a number of occurrences (i.e. - 3). When a value is typed into B1, I need it to generate a new list; repeating each value the specified number of times & then repeating with the next value on the...

<colgroup><col width="64" style="width: 48pt;" span="7"> <tbody> Looking for the following resuts: Year to date Blue Florida April 20...

Hello all, I have a macro that works, but I am trying to make it a little more efficient so that when changes happen, it will be easier to update in the future. The main idea is that I call for a file to open, do some stuff and then save and close it. The problem is that I have to do this with...