1. A

    Printing only rows with data?

    Hi all! I'm pretty sure this may have been answered before, but I'm self-taught in excel and know about 100% of nothing as far as coding goes, so I need to try an get this explained super simply if possible. The post I think I found before talked a lot about coding and something like VBA and I...
  2. R

    Print All Text Black

    Is there a way to have all the text in a worksheet print in black, so that I can still have a color image print in color? I cannot choose the print black and white option in page setup because it turns the image black and white too. I am trying to figure out a way for users to easily identify...
  3. R

    How to find a range of words in a list of row?

    <tbody> Hello All, Here is the sample strings in (A2:A11) result(B2:B11) Lorem ipsum dolor sit amet, amber amber consectetur beige adipiscing elit. amber|beige Nunc azure dictum black odio light blue quis nunc imperdiet viverra. black|light blue|blue Sed at beige beige beige amber...
  4. T

    Find Text in Group

    Hello, Need your quick help. I'm trying to write a formula where from a group I can find if it has a text (specific/partial). "Has Black?" is the result I want. <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Animal Color Animal Has Black? dog...
  5. W

    Trim formula working on one cell, but not working on similar adjacent cell

    Hello All, This thing has stumped me. I trying to separate a bullet point list from one cell into different columns using this formula: =TRIM(LEFT(SUBSTITUTE(MID(D4,FIND("|",SUBSTITUTE(D4,"•","|",1))+1,LEN(D4)),"•",REPT(" ",LEN(D4))),LEN(D4))) It works most of the time, but sometimes it...
  6. E

    Roulette Excel Spreadsheet Betting Tracker using IF Formula

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

    Help Creating Pivot Table

    Hello, My current raw data table reads: Monday Tuesday Black Red Black Red Car 10 15 6 7 Horse 4 2 2 6 Bike 7 3 4 5 Wagon 8 1 5 3 Is there any way to pivot this and have the filter as the...
  8. L

    Need 2 Formulas

    I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5% Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5? Is there a way D1 can be Red if the...
  9. K

    Border around cell that hover over

    So my sister has an eye degenerative disease and has a hard time seeing the green highlighted border of a cell in Excel when hover over or clicked on on comparison to the black borders of the rest of the cells. Is there a way she change change.the colors so she can better see them?
  10. S


    Hello, So the cell contains "MattressSofaCouch-1", I currently have the isnumber function to identify whether it is a mattress, sofa or couch but I need an adjustment to the formula to designate the "-1" as the color black. Right now when I use the ISNUMBER formula and add the "-1", it pulls...
  11. G

    VBA code to change font color from red to black

    Hi all, I´m looking for a code that changes in all the workbook, all the text that is in red colored (red font), into black (black font). Would it be possible? Thanks in advance!
  12. M

    extract a list of colour combinations from a table

    I have a table of which this is an extract: <colgroup><col><col><col><col span="2"></colgroup><tbody> design foreground background size type plain white black XL T-shirt plain white black M T-shirt plain brown yellow L cap paisley blue yellow L cap paisley blue yellow M T-shirt...
  13. M

    find and list top 10 items in a table showing their row and column labels?

    I have a table which summarises the number of sales of tshirts of each colour combination (its actually much bigger than this) I'd like to show a list of the top 10 most popular colour combos so somehow i have to find the highest 10 values from these cells and display a list of them, in order...
  14. T

    Search content in another cell as word, not sentence.

    Hi, I am working on formula to help my staff on their data entry. We have the primary code in column A and we need to input color of each item in column B In column C, we then have this formula, =IF(A2<>A1,B2,IF(ISNUMBER(SEARCH(B2,C1)),C1,C1&","&B2)) it basically check if all these 3 input...
  15. M

    Transposing n rows into columns

    Hi everyone. I am trying to make a chart with demographic data, and I need to rearrange the data. I've been searching for a thread about this query, but all I found refer to Multiple Rows to Single Columns, and resulting columns on top of each other. My dataset is a table of 103x496 and I cannot...
  16. J

    Print Black and White - Don't Hide Icon Set

    I have a spreadsheet and I have conditional formatting on all cells so that if a formula exists in a cell it shades it a gray. this is solely for my benefit when i'm in the workbook. I also have a column that contains conditional formatting to provide a visual cue using icon sets which is for...
  17. Trevor3007

    black border

    hi, i have the following code:- Sub FormatRange() Application.ScreenUpdating = False Dim LastRow As Long LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Dim lCol As Long lCol = ActiveSheet.UsedRange.Columns.Count With Range(Cells(1, 1)...
  18. R

    Best use of histograms on a B&W printer

    I am using a black and white laser printer, and want to make the three values in the histogram have more contrast. The code I am using is as follows: ActiveChart.PageSetup.BlackandWhite = True . . . ActiveChart.FullSeriesCollection(1).Select With Selecton.FormatFill .Patterned...
  19. U

    Formatting Challenge-Microsoft says it can't be done ???

    Does anyone know how you can format one digit in a cell without formatting the rest without having to do it manually every time ? For example if 53 appears in a cell I would like for the 3 to be red and the 5 remain black. Every time the 3 appears in my data I want the 3 to be red, for...
  20. U

    Single number of 2 digit number formatting

    Is there a way to change the color of 1 digit in a 2 digit number in a cell? For instance if the number in a cell is 53 I want the 3 to be red and the 5 to remain black, and every time a 3 appears in my data I just want the 3 to be red. So if I type 693 I would like just the 3 to be red and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back