red

I've got a List with player names and whether they shoot right or left (NHL). The players names who shoot right are colored red. When I use the dropdown list I want the red color to remain with the name. How do I accomplish this? Thanks

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

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

Hi I want to ask a question to the user and give 3 choices answers. Q) What is the color of the sky? [x] blue [] red [] green C1 = correct If user click on Blue then C1 will show correct. So I linked the first checkbox to B1 and I wrote in C1 the following =if(B1=true, "Correct", " wrong")...

I am trying to find a code that will work to change sheet tab color to red if a cell in a different sheet has a date that is less than today's date in it. Ex. Column H in Sheet1 has registration dates in it, Sheets2-30 have vehicle information in them. Sheet2 tab turns red if the date in H1 of...

My speadsheet calculates the 15% and 20% weight loss from a start weight and the cells automatically change orange or red But I also need a formula which calculates the daily change in weight expressed as a % , whether increase or decrease, this can be shown as green cells and ideally when...

I have a sheet which has a list of numbers ranging from -10000 to 10000. I need an IF statement which says if the number is less than -1500 then it should read "red" if it is less than -500 then read "amber" and if it is greater than -500 then should read "green" I can get it do parts but...

Dear Team, I am using the mentioned vba code to find text in font color red in powerpoint . The below mentioned code i was using to find red color font text in ms word. Sub newred() Selection.Find.ClearFormatting Selection.Find.Font.Color = wdColorRed With Selection.Find...

I have a column that looks for duplicates, and makes them fill color and font color red. What I would like to do if possible is in another column look at conditional formatted column and return text\values or anything that has a duplicated cell which is fill color red and font color red. Is...

Hi all, I have data that is always changing. I need a macro that searches through column AH for the word "Black". If the word "Black" is found then that row gets selected and the font gets changed to red. I have to code for the red font, I just cant figure out how to select the specific row...

Hi, I am using this working code shown below, It works like this. I complete each cell in my new row. In cell B7 i enter 17 characters,the 10th character is shown in a red font. Cell E has a date automatically entered due to this 10th character. If for any reason i decide to delete row 7 at a...

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

Hello, I'm having a hard time finding the right formula for what I need to do. I need the cell to turn RED if the date in that cell is more than 10 days from the date on another cell. Example: a date will be inputted in cell C3, then another date will be inputted in cell E3. If the date on...

I would like a colored row on a certain date to turn from red to yellow, how would I format that?

I have a bunch of unique numbers in cells a2:a310. they are from a barcode scanner. the first 10 numbers are the same and the rest are different . when i highlight column A and set conditional formatting to duplicate are red , all cells turn red even though the numbers are different . I have...

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

Hi, I'm trying to create a basic excel formula based on red/black bets on roulette. The basic layout is currently like this: <tbody> A B C D E F 1 Bet Round Red Stake Black Stake Bet Outcome Bet Profit/Loss Running Balance 2 Round 1 1 1 Black 0 0 3 Round 2 2 1 Black -1 -1 4 Round 3 4...

I've got a spreadsheet that I'm having trouble with turning the conditional formatting OFF once a "Completion Date" is entered into a target cell. In this sheet, staff enter an "Intake Date" in cell D4, which then allows other cells to populate due dates for report items. The Conditional...

:eeek: I thought that some of my other questions were weird... I have a large, multi-page spreadsheet with lots of tables & formulas (100's) Many of the formulas look-up data on the various tables & then return the next set of instructions: IF(A2="RED",[Do This],IF(A2="YELLOW",[Do...

Hello - I am trying to pivot the same data multiple times to understand the all sub-level components of my finished parts. I have a list of parent items and the items that make them up which looks like this: Parent Item (A) Component Item (B) I can pivot the parent to component to get all...