purple

Hi, It looks like sumifs formula has got a lookup limit of 15 digits and is there any better way to work around it? I tried sum(if under assay formula but hope there is something else quicker we can do? In addition, if I want to use sumif does not equal to a particular value in a cell i tried...

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

Hi folks, In Column A1 to A10 each cell has a different number.However if two numbers are the same I want to colour the background a certain colour(lets say green). If 3 numbers are the same the backcolour will be red and if 4 numbers are the same the number will be purple. Is this possible...

Hi, I have a look up table that looks something like this. 2 columns, lets say in this example a color and company. RED COMPANY 1 BLUE COMPANY 2 YELLOW COMPANY 3 YELLOW COMPANY4 RED COMPANY 7 BLUE COMPANY 10 BLUE COMPANY11 BLUE COMPANY14 RED COMPANY 20 RED COMPANY 19 PURPLE COMPANY 55 PURPLE...

Please can you advise me on how I can sum a column of numbers (C) which have a specified criteria (A) and background colour in another cell on the same row (B) and when sum the value of another cell. The colour is manually entered not conditional formatted. A B...

Hello, I've been tasked to customize the "Simple Gantt Chart Template" based in Excel to an Annual Template as oppose to the weekly one that's already in the Simple Gantt Chart Template. I need to adjust the following: 1.) I want the progress bar formatting to change from purple to the...

Given the following <tbody> Andy Bob Jeff Blue x Black x Purple x Green x Yellow x Red x Brown x Orange x </tbody> How can I get the output to be (or can I): <tbody> Andy Bob Jeff Blue Black Purple Green Yellow Red Brown Orange </tbody> I am...

Hello All, I have code here... Sheets("Cherry").Select ActiveSheet.Tab.Color = vbRed and it works fine But when I try to use the same code for "Grape" and "Purple", it doesn't work Sheets("Grapes").Select ActiveSheet.Tab.Color = vbPurple Is there a color chart for all...

Hey guys, I'm trying to create a dynamic list based on the user's selection of yes/no/NA answers. If the user selects No for one of the questions, the list should generate a message. Example: Questionnaire: <tbody> Question: Answer: Message if Answer = No Q1 Yes Q2 Yes Q3 No...