highlighted

Hi - How do I use the highlighted cell as the row to paste into? So if some highlights Cell A10, then items would be pasted into row 10. thanks!

How do I get excel to Highlight words that have the same first two characters from two different cells For example <tbody> A B 1 abfgr( this should highlighted since the same first two letters is found in cell B2) gh( this should highlighted since the same first two letters is found in cell...

This is a little hard to explain but I have two things i would like to achieveI am an extreme newbie so any help even written formulas for me to try would be wonderful 1. What I would like to achieve is starting from cell A2 and working to the right of the cell---> to the next cell B2 if the...

I have a listbox in my userform. Its set us as a single selection. When the user clicks on it, they complete som data manipulation, and then the selection is eliminated from the listbox. I have run into a problem. As the selections are removed one by one, eventually there is one left. It gets...

Hi, I have a worksheet that has 20 different expiry dates, they are individual cells, not in a range. If any one of these cells become expired I would like the tab to be highlighted, I am a complete beginner at this so sorry if I've got any definitions wrong and thanks.

I'm at a bit of a loss here. On every version of excel I've ever used (currently 2016) when you disable "Allow Editing Directly within Cell" you can then press F2 where the cells used in the formula will be highlighted by various colors and with the left mouse button you could move the...

Hi On sheet1, column B, I have a list of reference numbers. In sheet2, column A these may or may not appear. In Sheet1, I would like the Cell in Column B highlighted IF it does NOT appear in Sheet2, column A Blanks should also be ignored Many thanks

Hi, I was looking for some help. I have a row of numbers and would like to conditional format them so that the 2 lowest values are highlighted. Example: 13 15 8 10 12 8 5 9 In the above example, I would want the 5 and either of the 8's highlighted. Doesn't matter which 8...

Morning, I have a userform which i can select a customers name from a ComboBox currently called NameForDateEntryBox,once the name is selected it is then highlighted blue. I then manually select TextBox7 where i enter a date. Can you advise a simple code then once a name is selected /...

Hi, I am trying to write a VBA to delete unnecessary rows in my spreadsheet instead of doing it manually. Row range can be up to 1000+; column range is from A to R. Negative values cells will be highlighted in red and they are spread out randomly from column (E:N). There could be 3 negative...

Hi everyone, Im looking for 2 formulas, I cant really make 2 posts for it because they run together. The first one would be to take the data from EC3:EY3 (with blanc columns in between ) which are " Span numbers " and rearrange them in numerical order starting from FA3 to FS3, its always gone...

Dear Community I need a formula that highlight values which total is zero but have the same reference ID I want to have the below results. <colgroup><col span="2"><col></colgroup><tbody> ID Value Result A 1 highlighted on color green A 2 A -1 highlighted on color green C 4 C -2...

Can someone please help me? When I copy the formula below(which works) while recording a macro, it seems to have parts of the formula cut off in the code (highlighted below is what the macro creates) for example, the original formula, looks in the data sheet for "highway Tripper", as you can see...

Basically I'm looking for a cell to fill in another cell if another cell is highlighted. My issue is: "If a cell in G column is highlighted then take the text from in cell J (of the same row) and copy it over to cell d" Warranted column A and column G have a conditional formatting whereas if...

Hi I want to highlight the whole row if the cell in column D corresponding to that row is = "no show". So if D3="no show" then Row 3 will be highlighted to yellow for example. What I did, I highlighted the whole sheet, then went to CF-->Formula and wrote D1="no show" but that only highlight...

I want to conditionally format (highlight) a certain cell IF any number in a particular cell in that range is above 3. My rows go left to right. So in #1 Row, I want the #1 to be Highlighted because the 3.5 is above 3. The #5 would be highlighted as well cause it has two such numbers 3.2 &...

I am comparing a spreadsheet vs database information. I am given a spreadsheet of addresses and I have compared the zip codes by Conditional Formatting, highlighting the duplicate values. Is there a way to only show all the data on the row of the selected area where the zip code is highlighted?

Hello. What I intended is for the cell in Column C to be highlighted if the value does not match with cell in Column D. The cells in both columns are not in the same row, so to know if it is matched is with respect to Column B and Column E. (i.e.C6 will be highlighted but C5 will not be...

Hi, I have highlighted duplicates from two columns using conditional formatting. I now want to pull the data from the whole row of the highlighted column. Any ideas?

I have a list of dates in column A and need to identify (probably by conditional formatting?) which dates occur between the last but one 21st of the month and the last 20th. Thus if today's date is the 21st September, entries in the list between 21st August and 20th September should be...