highlight

Hi There! Hoping I can explain this well enough. In the attached sample file, I have product listed down column "C" to send to a store; then all of the stores listed "E:L". I want to have a macro in my personal book to read the active sheet and tell me by highlighting the cell red, if it's a...

Hi there - beginner to VBA here, so what I'm about to ask is way out of knowledge base, but am wondering if someone can help. I would like code that is able to do the following: 1. Within a range of data highlight empty cells in yellow up until the last populated row. That will need to be...

I'm looking for a best way, most likely via Conditional Formatting, to highlight 3 reoccurring from B within 3 days time frame from A I've managed so far to get 3 reoccurring but for just 1 day So, all those 4 rows with PC should be highlighted, not just 3 of them Hope you can help

Hi All, I have a sheet in which I need to sum values based on condition that these cells need to be highlighted/filled with a color and it should be visible in filter. I found following code which is working for Highlighted/filled cells but it is summing up all visible and hidden cells...

Hello, I'm trying to highlight all rows based on whether values in a certain column are consecutive numbers. My spreadsheet is thousands of rows long and each cell in column I contains an 11-digit number. If any of those numbers are consecutive, I would like the whole row highlighted. I tried...

Hello, I'm trying to figure out how I can highlight cells that contain duplicate values, but only if they are in the same column. Obviously, I could just go column by column and add a conditional formatting rule for each, but I'd like to be able to use one rule that applies to my entire range...

Hi there, I am new to the forum since today because I am facing a problem highlighting duplicates in a large Excel file (at around 200.000 rows). Situation: Our suppliers sent a list with over 200000 rows in a file. I only need 1800 of them. I can identify the 1800 needed rows by the SKU...

Hi guys, I found a very good VBA code but I have problem. When this code face with #N/A it gave an error and doesn't match. Can you help solve this problem and also I want the same code to green matching. What I should change ? Note : after my searching i understood that, it is because #N/A ...

I think I may be asking the impossible here but here we go! I am trying to make conditional formatting across multiple sheets. Tabs: TIMETABLE 1, TIMETABLE 2, TIMETABLE 3 If B10 in TIMETABLE 1 (tab 1) is used in B10 in another tab (TIMETABLE 2 or TIMETABLE 3) , highlight both cells red. Is...

Hey All, Could you please kindly advise as to what's the best way to loop through cells and paste as value a result from formula in another cell? If the result was copied, the cell should also be highlighted in yellow. In short, formula in column AY throws a desired result or states FALSE. If...

Hello, Conditional Formatting need to Highlight cell from B:D based on value in column A any order should match 3 digits of column A ABCD1237345678902456789023567890227734567890245678902356789034793456789024567890235678904578345678902456789023567890 Thanks for your time and help

Hello everyone, I have a table with a lot of prices for some products, and from my 2nd excel document i pull data to update those prices with =vlookup function. But it takes a lot of time for me to go from 1-2-3-4-5... and look at the prices and see if any price changed. Is there a way to...

I have a number of cell that are highlighted, I want to create a formula, that will produce a number based on if the cell is highlighted in increasing order, See Below: THANKS!!

Hello all, I'm quite new to VBA searching for guidance. I was wondering if anyone had an idea how to write an excel VBA script that would do the following: 1. Search column B for a cell containing "Checker Plate". 2. And if the adjacent cell (Column A) contains a "6" or a "9" then highlight...

I know I am overthinking this. It is not a difficult task. For the life of me, I cannot figure out a simply Conditional Formatting. I have 2 pieces of criteria: If the value in cell D23 is equal to or less than 0 then highlight D9. If the value in cell D23 is greater than 0 then highlight D24...

Hi, I'm trying to compare two columns. When the value in column 2 is higher than in column 1, I highlight the cell. I've selected my first cell (let's say B1) and went to Conditional Formating > Highlight Cell > Greater Than and selected my first cell from my first column (A1). Now, I need to...

Hi There, How can I have the return value highlight in another workbook before being matched and copy into first workbook. =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Thanks in advance

Greetings! I'm trying to get find a way to highlight cells so I can see if duplicate values exist during the same day and time. This so I can easily spot these duplicates and change my dates/times in L column to avoid these. In other words: How to highlight duplicate values in cell range...

Hi, is there any way to highlight the cells in a range, if: the value is more or less than 0.2 to the nearest 1 there are already a formula in each of those cells in the range, which will change according to what i change at the other cell. example: if cell value = 6.09, highlight if cell value...

Hi, Is there a way to highlight duplicates in comma delimited cells that are in a column, I want to compare all comma delimited text values in every cell in a column and highlight the cells that contain the duplicate text, Can someone help with this please