black

<tbody> Good day. this formula works in the same workbook. =VLOOKUP($B$2,INDIRECT("'"&$A7&"'!$A:$DB"),75,FALSE) but when i use it with different workbook is not working. SUMMARY WORKBOOK <tbody> Stock Code SHOES1 (input code) Description GIGASHOES (=VLOOKUP(B2,Sheet10)!A:F,2,FALSE)...

Right now, I have the rows conditionally formatted (to become black) based on the value in column B. If there are values in row 7, but B7 changes cells D7:K7 to be formatted black, how can I automatically delete the values in cells D7:K7 based on the conditional format?

In a cell you have in black font 'something', and then another word in a red font. I can use conditional formatting to make the cell font color, let's say, purple, but it only changes the black font word. Any ideas?

Hi I have a table and in column c I have cells which have black font and cells with a blue font. When the toggle button is pressed I want the cells which are black to remain black font and the cells which are blue to match their interior colour, in other words, they seem to disappear. The...

Hi, I would like to ask a macro where it will search through a folder and subfolder and put the result in columns in excel. Sample is : words to look in a note file - 'Note', 'black", 'white', 'blue' if 2 words found: column1 column 2 C:\document\txt1...

Morning All First, apologies if this is already answered in the Forum, but i could not find anything similar I have a very large data set in excel with 1000's of rows and i cannot uses simple filters as this is not appropriate to generate subsequent reports from the data, therefore i have to...

Hi, Im working in Excel 2016. I am looking to find out if it is possible to designate different sum ranges for one specific criteria in a sumproduct formula while the rest of the conditions apply to both. Example: <tbody> A B C D E 1 Color Month ForSale AM1 Am2 2 Black 1 Y 50 100...

Hello once again all, here is my current problem. I need to be able to conditionally format information in column B based on the conditional formatting of column C. Example: Column B contains several hundred entries and some have the same information but entered differently ("The dog is...

I would appreciate assistance with VBA code that would eliminate the vertical black boarders that I show outlined in red in the following image. I am trying to write code that would use the words in column A, “ADD”, “REMOVE”, “KEEP – Paid Advertisers” as the text that would indicate the...

Every year when I do my taxes, I take last years excel tax work sheet and copy it. Then I take all dollar values and change the font to red. This way I know they are last year values that havent yet been updated. When I type in the current values for this year, I want the font to be black...

Hello friends, Hope all is well! I have a format cell below. The cell displays values and an arrow. Is it possible to have the values black and the arrow colored? [Color50] #,##0▲;[Color3] #,##0▼ Thanks a lot in advance!

I have a table somewhat like: Red 20 Red 30 Black 30 Black 20 Red 25 Red 15 Black 40 Closest to: 23 I want to write a formula that will return the value in column B that closest to 23 when column A equals Red. In this case 25.

Is it possible to format text to white in column A if column B is unhidden but then format the text in column A to black when column B is hidden? All help gratefully received

hi working with Excel 7. seems all sheets have black background, with white fonts. It seems to be a default, in all workbooks. I'm trying to change the background to white with black fonts. using the fill icons does not do anything. how can i make the change in colors, and keep them as...

I have a data file containing data from several different countries, many of which use accented characters in their alphabets. The file has been unable to interpret many of these and replaced them a black diamond with a white question mark inside: � On my PC (Office Professional 2013), I can...

Hello, I have data set example as follows: I want to call out the duplicate names so if A! and B1 match AND B1 and B2 match then place an X in C1 and C2. Is this possible with a formula (not VBA) or other option? Thanks in advance! A1 Bob B1 Jensen A2 Bob B2 Jensen A3 Tom B3 Allann A4 Bill...

Hi, I have a list of 60,000 rows of data and in column A i have 23,000 different values. In column J i have multiple different codes, how can i find out what is the most common against different value of coulmn A. So for example i would want the answer for 1 in column A to be Yellow <tbody>...

I have a bunch of fields on a form where I entered conditional formula "Check values in the current record or use and expression Format on cells where the: Field Value is greater than 0 Then the formatting is set to make the fore color red if the value, which is calculated, results...

Hi, after searching the web and testing VBA codes, I've become stuck... I have a Cell Range - E8:J27: where all cells have a fill color of RED, and can change to either WHITE or BLACK which is determined by conditional formatting. For the desired outcome I am not sure if the cell range...

Hi everyone, I would like to be able to summarize unique values from two different columns. Here is my example: Column A (Month) | Column B (Name) January John Doe January John Doe January Clark Kent February...