highlight cell or row

I am trying to create a macro that will take the value from the active cell for the First and Last name in my "Unmatched Recipients" sheet (column BN) and find the matching value in column A (first and last name) in Sheet2. When it is found, it would highlight the values on Sheet2. I would love...

Good day everyone, I’m looking for some assistance building a macro that would trigger a Dialog Box when TODAY’s date is 90 days shy (before) of the expiry date, then 45, and finally the day of. Also, I would like to highlight the row of that date with a specific color depending how close it is...

Hi Gents, I have a sheet called "Orders" and all order numbers are in column A and estimated costs are in column B and actual costs are in column C. I already used a formula to highlight values in Orders sheet as C>B. On the other hand, I have another sheet called "Materials" and same order...

Hi Does anyone know how to make a whole row red if a certain word appears in a cell? Please find below a simple example: The data below covers cells A1:C3 and every cell in that range has a "-" with the exception of cell C2, which has the word "FALSE." I'd like to make the whole row red...

Hello Everyone, Basically I want to show how many people will be needed per station bassed on Cell O16's value. For example if O16 read 8, I would want cells D and E 5-12 to be highlighted. I'm sure this is a simple formula but I'm a neophyte at this. Thank you!

Is there a way to setup a conditional formatting formula to highlight if at least one cell on a row contains at least 1 of 145 possible codes. Column O contains a list of 45 codes. I need to know how to check that each row contains at least one of the 145 codes listed. There are over 1,000...

Hello, I'm learning Excel VBA and I would appreciate help. I'm trying to highlight a row of data in one workbook (Table 1) if criteria in column A matches criteria in column A of another workbook. I need help referencing the other workbook without naming it explicitly, the...

Hi, I am totally new to VBA. I am one of girls who can't code. =( I am so glad that I found this website. It has a lot of valuable information. I spend a whole day going through a lot of posts on this website to figure out how to write codes for a simple(?) task. (I thought I was simple...

Hello Excel Geniuses! Hope all is well. I am in need of some assistance, and I am hoping someone can help me here... I have a workbook where months, expressed as the 1st of the month, are in row 2. Each column to the right is the subsequent month. SO for example, 10/1/2015 in BW2, 11/1/2015...

I don't know if this is possible, but I would like to be able to highlight a row by using ctrl+F and by typing in what is in column A, be able to highlight the row in blue. When I type in what is in column A while it is highlighted in blue, I want it to turn green. When I type in what is...

Hi, I have extracted data from different tabs of a sheet named 'Hobby Card Macro Enabled.xlsm' into different corresponding rows of another sheet named 'Admission Database.xlsm'. I want that even the color of rows in 'Admission Database.xlsm' is same as the color of their corresponding tabs in...

Good morning, Operating System: Windows Vista, 7, 8. Excel Version: 2010 I am new to the forums here, and have been working on a spreadsheet which users would input time on and would also act as a cumulative time card. I have so far had a fair amount of luck with creating a spreadsheet that...

I need help finding a way to highlight rows while doing a conditional format for the unique values of a column. For example if column had the values 1 1 2 3 3 I would want the entire row 3 highlighted. Also if anyone knows a way to write a macro do the conditional format across workbooks that...

Hi I'm stuck with this one, the below is an example of what I'm trying to achieve. I need to highlight the rows depending on the values on D and F. I've done =NOT(ISBLANK($P1)) in conditional formatting to highlight the rows when a date is entered in column D but I can't figure out how to...

Hi, I have been trying unsuccessfully to create two macros in one dynamic worksheet (it changes all the time) using VBA. Ideally, macro 1 would highlight each row that has a match across columns A:D, and then macro 2 would then delete all matching rows. So, the worksheet is entitled "Template"...

Hi, I am trying to auto highlight a spread sheet, my conditions are a bit specific and this doesnt let me to get the right outcome. I tried many different kind of codes in <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0...

Hi, I'm looking to set my sheet up so that when I2 contains any text(date in this case) the whole row highlights indicating the package has been sent. <tbody> </tbody> <tbody> Title 1 Title 2 Title 3 Title 4 Title 5 Title 6 Title 7 Title 8 Date Shipped Title 10 Text1 Text 2 Text3 Text4...

2 Questions: (1) How do I adjust the range to start on row 8 on the "TO" sheet and start at row 5 on the "BOM Worksheet". When I've attempted to simply adjust "B" to "B8:B" or "P" to "P5:P" it skewed the matching capability. Sub CompareAndHighlightGreen() 'THIS ONE LOOKS FOR CELLS THAT >>> DO...