highlight cell

password a sheet or workbook but I still like to use Highlight like yellow or RED if I password the sheet or workbook I can not use Highlight

Hello, I need some help trying to figure out this conditional formatting. I've tried looking at other formulas and implementing them to my situation to no avail. I have the conditional formatting set up as to have anything that is greater than the max ID to go red, however if the max ID cell...

Dears, I need a "conditional formatting" to get highlighted if all the information are matching in all 3 tables like in the sheet.

Hello Gurus, Hope all is well. Could you possibly help be on how to code this? 1. In Sheet1, I need to highlight in yellow the text containing "Target" in column AZ. 2. Separate the data with "Target" text by adding a blank column 3. Add message box noting how many "Target" text are there...

Hello, Is it possible to keep or create highlighted cells ( last row cells ) if condition met? Mainly I need to highlight the bottom cells corresponding to each WK number that is smaller than the current WK number. I have looked if i can read the source of my listbox and keep the formatting...

Hey everyone! My computer is a Dell and my operating system is Windows 10. Can someone help me with a formula to solve this problem? I’ve been doing it (looking for the row of numbers) one by one and it takes too much time. I’d like to highlight numbers (in the same row) with numbers I copy...

Hello experts, I have an excel table which has hyperlinks in column D. I want to change the color of the cell to green after clicking on the hyperlink. What I want is not to highlight the active cell. I want the cell to have its color permanently after clicking on the hyperlink once. Can...

Mornin all. I have a code that selects certain cells based on the user's input and highlights them yellow or gray. If possible I'd like to be able to set the cells I want highlighted equal to a range of some sort then highlight the range so the sheet isn't jumping everywhere (by selecting...

Hi, How can I write a formula to highlight rows C-E , if they contain values in column N. I cannot use 'Conditional Formatting' as I have many values in column N. Many thanks

I have a spreadsheet which needs to be updated on regular basis. I wanna mark the cell requires mandatory updates with colors but I don't want those to be print. How to add non printable theme color for cell in excel? What is the best way to do it? Please help

Hello excel enthusiasts, I want to use a conditional formatting formula to highlight empty cells that fall between the first and last harvest period for each crop based on the column header date. The cells that should be highlighted say "fill". I've tried if/and formulas using relative cells...

Hi all, I have a calendar in year view that has the dates coloured based off of the type of event it is e.g. meetings are orange, reports due are blue etc etc At the top, I have a legend/key, and what I want to achieve is that if the user clicks the Legen that is for meetings (orange) then all...

Hello I am not a programmer so I apologize if my title seems confusing. This is what I meant: Cell D5 will automatically highlight as the data entered does not match with E4 for the same vehicle number. Cell D3 will not be highlighted as the data entered matched with E2 for the same vehicle...

Hello, I'm new here and I've been scouring this forum and the web for a solution to my scheduling conundrum....I have workshop and I want to be able to know what areas will be busy in the coming weeks/months, based on the current demand. So, I have a table where I input new jobs and I want...

Hi Excel gurus! I was just wondering if there's a way of highlighting cells that contain data validation? I have a spreadsheet that has random data validations across each row, I was wondering if it's at all possible to highlight these cells (that contain a data validation drop down) in yellow...

Hi, I'm fresher in vba ,This particular excel is meant to be put in a share folder where team members are supposed to fill it. I want to popup a error message before saving. The requirements are 1.In a row , the highlighted columns must be filled(error msg before save if not filled) 2.select...

Hi, need help with highlighting cells that don't fall with my range of specifications. My spec is 40-60. I would like to highlight the values in the data cells which fall from 0-39 and from 61 up. I'm sure it is an easy fix. Can anyone help me with this one?

Hello All, Trying again because I definitely need help with the macro. I can't believe the response and how helpful everyone was last time. Hopefully I can get the same results this time around. Okay - I have a spreadsheet with multiple columns (A through N) and around 18k records. I need help...

Hello - I am looking to use conditional formatting to highlight a cell red. I have 2 columns of text on separate sheets. If the text is found in column A on sheet 1, and its also found in column A on sheet 2 - highlight the sheet 1 text red I tried to use a formula to determine what cells to...

Hello all! Thanks in advance for any help this is my first time posting! I have a spreadsheet that has a value entered in call it cell A1. The number will be either 8,10,12,14,16,or 20. If 8 is entered I want to highlight cells A2 thru A5. If it is a 10 I would like it to highlight A6 thru A9...