green

Hello, Looking for some help if possible. I tried to be as detailed as possible Any help would be great! I have a range of data (B2:D4) that has various entries. I would like to find out how many unique entries there are and how many exist for each. Data B2 to D2 = Blank, Gray, Red B3 to D3...

I am trying to identify duplication of words between cells and am hoping this can be accomplished with VBA Here is a sample of the input and output. I am comparing string 1 to string 2. String 1 String 2 Output red orange yellow green...

Good Evening, I have a range of cells that are filled with text that is either Green, Amber or Red. If all the cells are Green then the answer is Green, if there is a mix of Amber and Green then the answer is Amber, if all the cells are Amber then the answer is Amber, if the cells are a mix of...

Hi there, I’m trying to separate style and color. My file has products like ABC top in red ACF bottoms in green A C B top in blue I need to extract ABC,ACF and A C B in these examples. Can you help think of a formula that helps? Thanks a lot!! Chris

Hello Friends, I need help with conditional formatting. I set two conditions on a cell that if a cell value is lower then 0 then red if a cell value is greater then 0 then green conditional formatting is turning the cell green even if it returns text "OK" as an answer I am using this...

I am having 2 issue with my conditional format formula. I am trying to work out a formula that allows me to detect new entries daily. So what if i put an entry in today tomorrow it would be gone until a new entry was made that day. Below is what i have already but it seems to be constant...

I am trying to conditional format a row to accomplish this. I need cell A1 when it contains the text “Sell” to fill color, Cells (A6:A10) to turn lets say Green. Every thing I have tried so far has failed, this is just one of several formulas I have used IF(C6="Sell",IF(B6:B10)) Thanks in...

I would like to set up CF for "No Shows" that appears in Col A I have set up a formula =ISNUMBER(SEARCH("No Shows",A2))=True The Rage is $A:$F It is highlighting all cells in green. It would be appreciated if someone can assist me

Hi, I have a table that is dynamically created. ........S.............T............U...........V 3......apple........45.........24..........red 4......pear..........10.........26.........red ... 12.....banana.....13.........23.........red Column V can be either red or green. A second table...

Would very much appreciate assistance with the following. I have a long list of data most of which is separated into blocks of 6 with a blank row in between. Occasionally, I encounter a block of 5 and I would like to insert a row after item 5. 1 Blue 2 Green 3 Orange 4 Red 5 Brown 6 Black...

Trying to come up with an IF formula that gets to the "Final Choice" selection in the last column (E). Choice #1 will always have priority over all other choices. Thanks. <colgroup><col span="4"><col></colgroup><tbody> <tbody> A B C D E 1 <tbody> Choice #1 </tbody> <tbody>...

I have two issues I'm trying to solve 1: I have this: <tbody> Doug Before 7 Doug During 4 Doug After 9 Jim Before 3 Jim During 7 Jim After 4 Karen Before 3 Karen After 6 </tbody> And need it to look like this <tbody> Name Before During After Doug 7 4 9 Jim 3 7 4 Karen 3...

Good Morning, I am attempting to count the word GREEN, (i learned my lesson on colors a while back) Seems a simple thing, guna feel dumb when this one comes back. Below are two of many attemps. (A5 is where the word GREEN is. =COUNTIF((A$10:$A$72, $B$11:$B$57), "GREEN")...

Hi folks, Need your help. I'm trying to find an equation to insert into cells E2:G5 that will look for the number of occurrences of the number “1” in a row, and then output the column header. I’ve been googling, and it seems this would require an equation using a combination of index, match...

Hi all, I am not Excel proficient so sorry if this is a dumb question. I’ve spent over an hour trying to find help on Google. Im trying to create a table with the same data in the column and row headers to show possible combinations and the results that they created. I also need each new...

Hello, I am trying to count the number of instances a certain value (Company) is listed in a conditional formatted cell, where the conditions are as follows: if cell value for # of Days <4, highlight cell green; if cell value is between 4 and 9, highlight cell yellow; and if cell value >9...

I am hoping someone can help me as I am losing the will to live. I am using conditional formatting to determine whether a gap has gone up or down from the previous term. It is mostly working but for some reason on a few of the data cells the wrong colour is given. I am using the formula...

Hi everyone, I would appreciate if anyone can help me with theis code: Sub pairs() Dim sh As Worksheet, tb As Long, c As Range, sVal As Range Set sh = Sheets(1) 'Edit sheet name tb = sh.Cells(Rows.Count, 1).End(xlUp).Row For Each c In sh.Range("B2:B50") 'Assumes header row...

I have two cells on one worksheet that are in random locations. One cell is named A and the other is named B. How do I get the color of cell A to be the same as cell B? Cell A is currently red but cell B is green. How do I get cell A to be green without using vba?

Hey there!! I have a problem with my worksheet. <tbody> A B C D E F A/A name ΠΕΡΙΟΧΗ ΤΚ REP FOCUS 41308 ALBERT NAME ATHENS 33051 109 1 21776 KONSTANT NAME ATHENS 35001 109 2 38235 TSAPROS NAME LAMIA 35002 109 3 40982 ANESTOS LAMIA 35004 109 4 35287 MATSOS NAME MIKONOS 35004 109 4...