black

  1. C

    Formula question

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

    Color Font to White

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

    How to create a Reset instead of clear all button

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

    create checkerboard with alternating patterns

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

    Shading between lines on graph

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

    Keeping cell colour

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

    Return multiple values from a single cell using a named range and INDEX/MATCH

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

    Reduce color saturation/intensity on pie chart?

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

    Custom Format 2 Colours

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

    Listbox Formatting issue

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

    Test

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

    sum by item no and number

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

    Extract rows based on matching criteria

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

    How to check for multiple keywords on a text and return back one or more creteria

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

    vlookup - need to grab multiple rows of unique data; instead of the same data over and over

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

    stacked column chart

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

    Dynamic Lists

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

    Format Table Borders

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

    Can I Use a Formula with Data Validation>List

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

    Array or SumIF Formula

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top