black

I have two tabs, lets call them White and Black. In White I will record data, I.E cell A1 is a name, Chris. cell B1 is a number, 200. cell A2 is Jen. cell B2 is 300 In my Black tab I have the same column A, Chris, Jen, etc. But column B i need it to pull directly from Chris’s or Jen’s...

Range("B4:F4").Select With Selection .Interior.ColorIndex = 1 .Font.Name = "Calibri" .Font.Size = 12 .Font.ColorIndex = 0 End With Hello All, I'm trying to write a simple code that will turn range B4:F4 Fill to Black, but the font to white, so it will show in the black field. I'm having...

I'm changing the background color of cells from black to green when clicked once. I can change the background cell colors from green to black when I right click. Is there a way to create a Reset button that will change all the changed cell colors back to black from green when clicked instead of...

I'm creating a video game that uses an 8 by 8 grid. I need half of the 64 cells to be black and half white. I'm using conditional formatting to highlight the cells white or black. I've got a randomizer to randomly make the cells either black or white. But, I can't figure out a way so that - no...

Hi all, I'm trying to shade in between two lines one which is revenue and the other is cost over a period of time. Naturally they cross each other. So far I have been able to show one in black when in "profit" and in red when showing a "loss". However, when they move from profit to loss there...

Good day,i hope my issue is an easy one to solve, i am totally stuck so here i go.I have a series of values in Column A Hello 1Hello 2 Hello 3Hello 4 (with hello written in black and the numbers are written in red) and in block G2 i have the formula:=CHOOSE(RANDBETWEEN(1,4),A1,A2,A3,A4) but the...

Hi there, First post here so I apologize if I breach any rules. I have scoured the internet and this forum and so far been unsuccessful in finding a solution to my problem. Admittedly it is likely that I don't know the correct way to ask the question. Hopefully someone here can help me with this...

I have a 20-slice pie chart. How can reduce the saturation/intensity of the colors on the chart so that 1) they don't use as much toner, and 2) the black data labels inside the significant items are more legible.

Hey, I'm trying to show my percentage changes with percentage and up or down arrow. I've used the custom format for green for positive and red for negative but this makes the number coloured aswell when I want to to retain as black. [Green]0%▲;[Red]-0%▼; I noticed I can't use this...

I have a bound Listbox on a form. The formatting is White background (back color #FFFFFF ) with black font (fore Color #000000 ). It is a continues form, so it shows many records. my dilemma is that all listbox in most records appear with a Black background and white font (not all Listboxes...

To be honest, I don't even know how to explain this fully in words, hoping the table will illustrate the dilemma. I have a data validation list in column F, with the appropriate selection made in cell E2 e.g. "white" in table 1. Table 1 <colgroup><col style="width...

I need to count not only by item no but also color. In the following example, the desired result is in blue. Row 5 and 6 have the same item number and color. Thus, the sum is 22 (16+6). The closest thing I can get is with the following formula, whose result is in the last column. It seems I need...

Hello All, I have a large list of data. Some of the cell font is black Some of the cell font is red I want to extract the entire row where column B is a duplicate AND where there is at least one duplicate in black and one duplicate in red. I would like to extract all duplicates in this case...

Hi Guys I am looking for a formula to help me like the below example <tbody> brown, blue, green, black if Cell A1 contain Blue and black and green return X1 in Cell B1 Car, Black, Battery, Monitor...

<tbody> Hello Everyone! I am trying to pull specific data (text and numbers) from multiple worksheets that are all in the same workbook and put it all inside one worksheet tab (like a dashboard). So far I have been unsuccessful. I know that vlookup is basically pulling the first lookup...

I have a stacked column chart for the data found in the range Sheet1!A2:A16. The stacked column chart uses an individual circle (black outline, white inner) to represent each student in a group of about 200 students. The x-axis bears the scale ... A+ A A- B+ B B- C+ C C- D+ D D- E+ E E- The...

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

Hi Everyone! Aplogies but I know this seems REALLY basic but i really don't know how to go thru (i've been playing around with excel for a long time now). Anyone knows how i can put borders (all borders) in my table with gray lines instead of the usual black (automatic) lines? The lines look...

Hi. I am creating a spreadsheet for product attributes, which will ultimately be used for generating product SKUs. On one sheet of same workbook I created lists for size, color, material, etc. and applied Define Name. On another sheet (same workbook) I created a drop-down list using Data...

I have my data as shown in rows G7 thru M31. I want to create a formula on each row in column M that takes the value in the quantity columns and the text values in the adjacent rows and gives a sum total. Ex: Yellow= 270, Blue = 2,430, Red =7500, Black 15360, and Green = 870 Here’s two...