green

Hi i'm sure this is really simple but i can't work it out i was positive numbers with a (+) and to be coloured green and negative numbers with a (-) and be red but i was 0 to stay black here is what i have so far for the formatting of the cells : [Green]+£#,##0.00;[Red]-£#,##0.00 this works...

Hi, First of all, thanks for taking the time to look at my post! I have multiple excel workbooks(all with just the one sheet) which is the daily output from another system. Multipleworkbooks sometimes have the same value in column A (essentially an ID number)but different values in the...

I have the following data which i need to process: - A B C Tom 39.57 Tom 117.73 Red Tom 195.89 Red Tom 195.89 Amber Tom 352.21 Red Jerry 508.53 Jerry 586.69 Red Jerry 264.85 Green Jerry 343.01 Red When the values in A1 and A2 are the same I want...

Hello gurus! I have a macro that works fine - for the most part. I'll put illustrations below to help with visualizing the problem. There are PO numbers in J, often more than one, separated by commas. There are also PO numbers starting in Z and continuing for an unknown number of columns -...

Hello, I have two tabs. [tab1] is a mailing list. This tab holds a bunch of information regarding a marking letter which was sent; information fields are: [Customer#], [dateSent], and [colorPrefer]. <tbody> [tab1] A B C 1 Customer# dateSent colorPref 2 12345 1/5/2018 red 3...

Hi All, I have attached a screenshot to help everyone get a better view of the request since after experimenting with Conditional formatting with formulas, I can't hit the correct way to it. Row 11 acts like a calibration form, Persons 1,2 and 3 will answer either Yes or No. If Master says...

Hi, I enter data into a worksheet via a userform and want to apply formatting to range (A:J) on sheet1 if column I (countdown in days) is > 5 (Green), <4.9 but > 2 (Orange) and <1.9 Red. I used conditional formatting but every time I delete a row the formatting does not work for the next row...

I want to enter text in a cell and then if the text that i enter matches text found in a cell that is part of a list, then I want the next 2 columns over to populate with numbers that correspond to the matched text. So A1 is "Blue". B1 is "10" and C1 is "50". A2 is "Red", B2 is "15", and...

Dear Community I need a formula that highlight values which total is zero but have the same reference ID I want to have the below results. <colgroup><col span="2"><col></colgroup><tbody> ID Value Result A 1 highlighted on color green A 2 A -1 highlighted on color green C 4 C -2...

Hey I have a table with 3 columns COLOR NUMBER1 NUMBER2 An example can look like this: <tbody> Color Number 1 Number 2 Green 1 10 Green 1 10 Red 2 20 Green 2 20 Yellow 3 30 Red 3 30 Green 4 10 </tbody> Now i want to answer this question. What is the...

Hello Gurus, For the following issue, I request your assistance. I have two columns: first one has Shirt color and second one has Sizes. Within a color, the order size received is varied, just as below <tbody> Shirt Color Size Yellow XL Yellow XL Yellow XL Yellow XL Yellow L...

I am having trouble adding one line to an IF function. I have learned that I can use up to 7 IF functions in a formula. My goal here is to get the difference between two dates and depending on the answer, the cell gives the green/amber/red answer. I have figured out my main goal, but got a...

I am trying to implement conditional formatting in a column so that if the first character is alpha in the range A through Z, or a through z, the fill color is green, if not the fill color is red. I started with =OR(LEFT(S2,1)="A"),(LEFT(S2,1)="B") etc with the fill color set to Green, then the...

Is there a simple count formula that I can input on sheet 1 in cell B1, B2 and B3 that I can copy down that will return the number of times Red, Blue and Green are listed on sheet 2? There are about 650 items that I need to have counted, so hoping there is something I can use that I can copy...

Hi everyone, I am struggling to conditionally format column D if column A has an "x" in it. Can someone help? So if there is an "x" in column A, I would like Column D to be green. Thank you, Deborah

Hi, Excel experts. Directly to the point: I need to find if the DisplayName matches with Payroll_Last AND any of the other two (Payroll_Second, Payroll_Name). If match, write "MATCH" in E. <tbody> DisplayName Payroll_Last Payroll_Second Payroll_Name Ross Eustace Geller GELLER ANYSECOND...

On my userform, I have a textbox (uf1vb1_OPS) that has code written to it when clicked by the user executes code which. I wish to mimic as a button. By default, the shape's SPECIALEFFECT property is Raised (1- frmSpecialEffectRaised). When the user clicks the shape, I want the button to appear...

I need to remove all duplicates and replace the value with a new value: <tbody> ID Name 1234 BLUE 1234 BLUE 3456 GREEN 4567 YELLOW 3456 GREEN </tbody> What I'm looking in return is: <tbody> ID Name 1234 MULTIPLE 3456 MULTIPLE 4567 YELLOW </tbody> Thank you...

I am hoping to get help on a conditional format issue. I want cell A1 to always display "Advertiser Name" cell with a simple conditional format of either red or green. I.E. I want the "Advertiser Name" in A1 to show conditional format green if the excel value in C2 is greater than 0. Using cell...

Based on odd or even value in column A want to color cells in columns B - K. If A1 is even want to color B1:K1 light green, if A1 is odd color B1:K1 darker green. If A2 is even want to color B2:K2 light green, if A2 is odd color B2:K2 darker green. Want to extend that formatting down whole...