blue

Hello, I'm trying to construct a formula that basically does this. I'll keep it simple. If cell A1 has "x" then G1 = "Blue" but if cell A1 and B1 both have "x" then G1 = "Blue Green" but if cell A1, B1, and C1 have "x" then G1 = "Blue Green Red". How can I do this? It' confused me for the...

I want to take the input cells, lookup their color values, then count the color occurrences. Probably need to use array but it's my achilles heel. Thanks!! <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> A B C D E F G H INPUT FRUIT...

Hello All, I have a site i am going to and it contains 2 drop downs. The selection of the first drop down triggers the options available in the second drop down to change. for example: drop down 1 could be Blue Red Green if blue is selected then drop down 2 will be A B C if green D E F...

HI Everyone, Does anyone know if it possible to change the colour of the Userform title Bar from Blue To Green. Our sheet has a green theme and the Userform look odd with a Blue top. Any methods tricks workaround would do. Thanks Tony

On my spreadsheet, is there a way I can highlight certain cells based on a selected cell? Basically, if I choose any cell between E3:E28 then the corresponding cells on that row from columns F3:AG28 will highlight in Blue? for example: I select cell E15. then all the cells in the column range...

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

Lookine for a formula that would look at a text cell with many identifiers, look for a specific word then look at an array and give the corresponding number that is associated with the word. Example: Blue Ford F-150 V8 auto trans The formula would look for a specific word like Blue then look...

Hello - can you help me with index & match formula. I've tried many times but I can't get it :eeek: I have a large data set that I need to update week as week go by so I need to do an index/ match to return information on another workbook automatically as I refresh the weekly dates...

Hi, How do i write a code to count total of "blue" and "red" in each school? The sum of blue and red have to be written at the cell next to the school. Colors other than blue and red are ignored. The rows in each school is inconsistent. <tbody> AB School 4 Blue Blue Red Red CD...

I am being sent table in followoing format I want to lookup based on name and color. Do I use a vlookup with offset? Index and match? ColA COLB John Red 12 Blue 324 Pink 34 Paul Green 1234 Red 1121 Any help is always greatly appreciated

Would appreciate help with the following. I have a large, unsorted table in one worksheet tab and I need to populate a sorted TOP N list on another worksheet tab where TOP is the largest amount of sales (largest being #1 ) but it has to be only with those of a certain color. I need to return...

Hi guys, I would like to thank whoever gives this a go ; I know that you guys do this just because you are nice people. So thank you. I would like to be able to do the following: The above black text is how my data is structured. This data constantly sees rows inserted and deleted, and...

Hello I have 3 worksheets with the same drop down lists but I want them to sync so that if "blue" is selected on worksheet 2 drop down then the other two worksheets also change to "blue" as well. Or the user can change worksheet 3 and then worksheet 1 and 2 change. Thanks.

Hi, I hope my question isn't too complicated. So say in my column A I have: blue red green yellow green yellow yellow blue ... Say in the end I have: 50 blue, 20 red, 100 green, and 180 yellow If I am narrowing down the my amount of rows to just 100. How do I make it: 27 blue, 20 red, 27...

Been searching and trying different macros for a couple of days now and haven't got things to work quite like I need them. Any help would be greatly appreciated. I have two sheets in a workbook Sheet1: 12345 Blue Red Green Blue-Red-Green 12345 Red Green Blue...

Is there a Macro or formula that will highlight or allow me to identify if a keyword exists in column A and B? I am looking to produce something in Column C to quickly match company names without doing it manually. Any solution will be gratefully received <tbody> Column A Column B Desired...

Hi all, thanks for your help in advance. Essentially reconciling very similar description data every day. Sometimes there are the same description which can give meaning to several columns (has tax, which company, which accounting expense code...) and very little needs to be done. The problem...

I am trying to better understand how to do this properly. I am starting with a basic list to get a better idea how to do this. Column A Column B Red 10 Red 12 Blue 21 Green 51 Red 70 Green 101 Blue 2 Yellow...

Hi All, I have been stuck for 2 weeks now trying to work this out. Can somebody please enlighten me? I simplified my request and changed raw data into words so it would make some sense of what I would like to achieve. There is a column B of dynamic mashed up data. This data needs to be split...

I have an Excel table formatted as a table. It has a light-blue table style (alternating light-blue/white rows). When I autofill a cell down through the entire column the light-blue background gets filled too. So for that column only the entire column is solid blue (no alternating rows). I...