highlight

Hi All, I'm trying to use Conditional Formatting to temporarily highlight multiple columns when any cell in those columns are active. Getting a single column to do it is working fine with this formula: =COLUMN()=CELL("col") The basic set up: Columns A:J are the columns that need to all...

Hi - I have a list of company plant and would like to dynamically-highlight the column title as each active row is selected, based on that row containing an 'X'. I've kind of got part-way there, but can't get it over the line... It works for the first line highlighted in the set, but nothing...

I'm struggling to find the write formula to write in Conditional Formatting to highlight ONLy the last cell in each column that has a value but only on the condition that a value above is met. So in my case if the value in Row 6 = "YES" then highlight the last cell in that column that has a...

Hello everyone, I can't figure out how to accomplish following task: I would like to use conditional formatting to color certain cells based on how big is the difference when comparing two cells above each other. Looking at the example below, Row 2 is the starting value and Row 3 is one that...

Hi all, I want to highlight cells when the row has 5 consecutive (or more) "Need attention". I only want to highlight cells with a word of "Need attention", and only if there are at least 5 consecutive word of "Need attention". The cell values are from a formula. Thank you in advance.

Hello! I'm trying to highlight the active row in a table. I have multiple table in 1 sheet and I already formatted the sheet to highlight the row when selected. However, when selecting the row in a table, it also highlight the same row in all the tables. is there a way to only highlight the row...

Hey Team, I have this code that highlights the entire row of the active cell. But I don't want it to mess with the cells I already have highlighted in that row. Is there a way to modify this to only highlight cells that are not currently highlighted?? This way my highlighted cells are not...

Hello together, please help me to extend my VBA code to highlight amount of cells (top to bottom) for a certain year based on how many tools are planned in separate table on the right side in attached "example". So far i wrote code that only counts tools for first country, but i dont know how...

Dear Excel Community ! I hope you are all doing well :) I come with a question that it seems not raised before as far as I know. I would like to get certain values within a pivot table getting highlighted dynamically provided that the total of theses values are higher than a threshold ( 80 %...

Hi all, I've scoured the internet for a solution and have tried coming up with a solution myself, but I'm just not proficient enough with VBA to be able to do it (and all of the solutions that I could find online involved a popup input box to manually enter keywords each time). I'm trying to...

Hi, I have a search button in a userform to highlight/select the matching list item based on the value entered in an inputbox that is activated by this search button. I would like to be able to select the list item, regardless of case sensitivity. With the code below my entered value does not...

Hello everybody. Pretty silly userform case study, to experiment, yet I'm facing a problem. The UserForm has 2 rectangle images, each in blue color (initially) and green color (when the MouseMove-s on it). When the MouseMove-s over the rest of the userform surface, the images are blue again...

Hey all, I'm doing some data analysis work on a bunch of spreadsheets and I'm seeking a way to automate part of the process. The entire row is highlighted based on the string value in column I, there's many different string values I'll need to create rules for. The longest string I've counted...

Hi I have written the following formula as a conditional formula =AND(C$20=Sheet1!$D$46,C21>=Sheet1!$D$47) which highlights values based on 2 criteria. This can give me up to 3 results and i only want the closest one to one of the specific criteria values not all possible answers. How do i...

Hi, I have watched videos and tried Conditional Formatting, Macro and Active cell editing, but still can't seem to find answers or any Etsy shop that has an electronic spreadsheet. I am sure this is simple, but need some help. I have a basic spreadsheet with rows and columns. So, for example...

Is it possible to use a if statement to highlight all the the numbers bigger than row D red for rows E-V instead of doing it individually. DEFGHIJKLMNOPQRSTUV3401-May02-May03-May04-May05-May06-May5BUDGET PER...

Hi, I'm looking to find a way to highlight rows within this range (not entire row), based on the following two conditions: If any date in column A is a weekend, then highlight that particular row and/or If any cell value in Column B at min. contains the word "TEST" (doesn't have to match...

First of all I would share my data but it contains personal information about patients so I will abstain. I will preface through: in my role I receive many reports containing patient data and there is a lot of manual leg work to go and tell where the fallouts are. In this specific spreadsheet we...

Hello world, so I have the sheet as seen in the attachment (I have included a picture) I have 2 columns, A for machines, B for products. I want to highlight those products that are created from both machines , so something like if duplicate and column A in the range of the duplicates contains...

I am looking for a macro to highlight rows that have an appointment that occur on the same day at the same time. See table below for reference. 04/11/2022 11:00 AM 04/11/2022 11:00 AM 04/11/2022 10:00 AM 04/11/2022 9:00 AM 04/11/2022 8:00 AM 04/11/2022 10:00 AM 04/11/2022 8:00 AM