black

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

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

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

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

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

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

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

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

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?

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

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!

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

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

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

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

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

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

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

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

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