yellow

Hi Everyone, I'm doing a quick check on a document and need to look at the formulas, there are a lot and some are disgused with same font and cell colour. I would like a macro the will go through every sheet and make each cell with a formula in it yellow to help speed thing up please help if...

Hey excel gurus, I would like my match and index formula to output me values that are reoccurring in my column A and not just for the first instance. for example my data looks like this <tbody> column A column B column C column D apple apple sweet banana banana yellow apple...

Hello I am looking for a script that will compare the values in two textboxes to see if the both contain same words. One box has "Small Yellow Car" Second box "Car Yellow Small" "Small Car Yellow" Etc Rules : 1. The order does not matter 2. The length of characters in both cases must...

Hello all! Have been a lurker for sometime and have found an incredible amount of useful threads here! However I can't seem to find anything that may help me with a notepad to excel macro ( I know theres a few but can't seem to get them to work :( ) So what I am trying to do is pull out Time...

I am trying to identify duplication of words between cells and am hoping this can be accomplished with VBA Here is a sample of the input and output. I am comparing string 1 to string 2. String 1 String 2 Output red orange yellow green...

I've searched the board and can't quite get the answer I need. If I have a cell that is set to Yellow fill based on a Conditional Formatting rule for that column, I want to be able to set a Conditional Formatting rule for corresponding cells in columns D and F so they also would be Yellow...

I need COLUMN A to sort all duplicates to the top IF one of the duplicates contain a cell with a specific colour. Example: <tbody> 234632498523 2523242237 8834523526 777777777777 24454784568 33333333333 CELL COLOR: YELLOW 573423452345 777777777777 CELL COLOR...

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

Hello, I have a spreadsheet with lots of columns. Some columns need items counted and some need items added. I'm hoping someone can help me with code to count and add cells in a column after the last occurrence of a series of items. Let me explain with an example. The code would start with Col...

Hello, First and foremost, thank you all for helping with my many Excel questions. I use VBA from time to time but I've never used Power Pivot (PP) before. In an effort to get accustomed to PP, I decided to create two simple tables, add them to the data model, create a pivot table from PP on...

Hi to all, these formulas do not turn out well blank =$J6="" or K6="P" today or date expired =<today()) (red) =AND($J6=TODAY(),$J6< today()) (red) date expires in 1 day =$J6>today()+1 (yellow) a help. max</today())>

Trying to come up with an IF formula that gets to the "Final Choice" selection in the last column (E). Choice #1 will always have priority over all other choices. Thanks. <colgroup><col span="4"><col></colgroup><tbody> <tbody> A B C D E 1 <tbody> Choice #1 </tbody> <tbody>...

Hi everyone, I've acquired a spreadsheet and the conditional formatting is broken and duplicated. Can someone elaborate on what =IF(A2=2,5," ") would do? The output is it highlights yellow when A2 has a numerical value of 2. But I can't figure out what the 5 or space do. The numerical value of...

Hi I have a column like the one below. I highlighted the cells and then dragged the autofill down. I got all cells value as = "red". Why is that? is it because they are color words. Thank you so much. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> red black...

Hi Guys, I have created an automated timeline in Excel and but I would like to have conditional formating between the starting date and the end date: https://ibb.co/WfnjvPq I would like to be shown as a bar basically, thus the cells in between SD and ED shall be automatically yellow. Perhaps...

Hi all, I have made a command button that gives me a MsgBox of the active cells interior colorindex, I notice the default is -4142. When I make a cell yellow for example the command button returns 6 Now if I were to make the cell yellow using conditional formatting then test the command...

Lets say A1-A100 have values (but not every cell) how do a write a formula so that corresponding cell in B1-B100 is filled in with a color? For example, it A20 value is 14, I want B20 to be yellow, and so on. I need a formula so I can then copy it to like 40 columns I am trying to make this...

Hi everyone, I have a question for creating a formula for conditional formatting. In cell A1 has a value 001 In cell B1 has the value 00 I would like to highlight cell A1 if the 1st 2 digits 00 are the same as cell B1 00 Color = Yellow Thanks

I have been trying for hours at various VBA codes but havnt found a specific formula that works. My team have a form that we use to generate work instruction which is basically merged cells with instructions prewritten that they highlight a number of cells ( A1 to A8 ) and then 'fill colour' in...

Hi I have a sheet that looks like this color | number now i want to count how many unique numbers i have of one color So the values can be like this in color column blue red yellow blue blue yellow red yellow yellow in the number column 123 22 123 143 12 132 123 22 22 22 So how many...