highlighting

Hello! I have a range of data C:BV filled with numerical values to the 5th decimal place. I would like a macro that finds duplicates in each column to the 2nd decimal place. So if I have 72.35854 and in the same column 72.35337, I want those to count as duplicates because they match to the...

Hi all, can anyonehelp with a formula. The purpose of this part of the spread sheet is toautomatically register the type of mailing done for later analysis - J3 has a dropdown where you can choose numbers 1 to 5.(This is letter typereference). N3 also has a drop down with several texts 1. Open...

I have conditional formatting set up on a large spreadsheet. In looking for exceptions above a given threshold, the formula basically says highlight examples where a given location is greater than 30 % higher than the average (greater than X*1.3). This conditional formatting seems to work well...

Howdy, I'm attempting to use conditional formatting to highlight every other group of similar rows. I've been using the following formula in conditional formatting and it's been working fine, but I'm trying to adapt it to look at two other columns as well...

Hi everyone, I'm learning VBA and am very unsure of what I am doing! I have columns A:K and need to highlight entire rows based on the top 150 values in column F. I know that there is conditional formatting for top values, but I can't seem to find anything that will highlight the entire row...

Hello All, I am using an IFERROR formula to accurately format my cells, however, I would like to have a flag icon appear instead of highlighting the cell, and I am struggling to properly do it. Is this even possible? Here is the current formula: =ISERROR(S90) Thanks, Andrew

Hi guys, all I want is to set up a format where if the value has a triplicate or more it would highlight. Seems simple enough and this was my formula, =countif($K$5:$K$30,$K5)>=$M$3 where M3 is 3. Or i tried =countif($K$5:$K$30,$K5)>=3 but neither seems to work correctly. Could someone let...

Column A in Book1-Sheet1 has a mix of blanks and values. Many of the values will be "U" followed by a 9-digit number starting with "1" (for example U101222333). In Book 2-Sheet1 Column A there is a master list of "U1" numbers. I can't figure out how to compare the Book1 "U1" numbers to the Book2...

Dear All, I have a list of "expected guest" in column A. In column B, I will enter their ID as they "arrive". I want excel to highlight in column A, those who have not arrived yet. So initially column A will have all the expected guest names highlight. As I am entering names in column B...

This is a request to Rick Rothstein and Peter_SSs who created the following VBA script in another Thread to do with underlining key words in a cell range > I'm looking for a similar solution except I would like the "Words" sheet "Data" to be converted to Bold and Red text. My Sheet with the...

Hello All, First time poster here (but I have been reading this site for years) Have run into a snag in an Excel project I am doing for work. What I am attempting to do is a little difficult to explain so I do hope I get it right on the first try. Firstly, the formatting that is done must...

Hello again. Looking for help again. Here is the table where D is Date money taken by client AW-BH are the months of the year each cell contains the % paid by client. Normally when the client is paying before or at the end of his month he pays whatever shows H column. As example...

Hello, I am working a spreadsheet for my job in which I need certain cells in the same row/column to be highlighted when clicking on another cell. For example, if I click on D9, I want cells B9 (same row) and D1 (same column) to be highlighted a given color. I want this same rule to be...

Hi all, Thanks for all you help on previous posts. I'm a young professional who uses excel often at work and its been very helpful to my development. I am currently struggling with the shortest way to tackle a project in excel. There is a set of data I have filtered based on select criteria -...

Hi guys, Im stuck at what to do? I have a work sheet in which I have to base a response from L4 to highlight the appropriate cell C4. Such as shown in the image attached. Can any help. thanks

I have several columns with drop down lists. Is it possible to format a row to highlight the cells with the drop down lists to notify the user to ensure those cells are filled out. For example, if someone types into a row, I want certain fields (the ones with drop down lists) to automatically...

I have a spreadhseet that I update and copy from multiple times a day. I am trying to automate as much formatting as possible with vba. I want to highlight a#,j# if c# is a certain date. I have a rough idea of the formula for choosing date it is the code I am having trouble with. I found...

Good Morning, I am trying to create 3 formulas to check column M for conditions. condition 1 is BLANK and C4 is LESS than TODAY(). highlight RED condition 2 is "Routed" highlight YELLOW condition 3 is "Filed/Complete" highlight GREEN i tried =IF(AND(M4=BLANK...

working on a basketball spreadsheet and have a few questions I have made a simple basketball spreadsheet that calculates FG% 3pt% pretty basic stuff, but i have run into some problems and the teacher doesn't really know whats going on i hope i can get some help and fast. My first problem was...

2003 / w7. I have a series of textbox(s) in which the user enters data. I'm using the data that the user enters to control whether I advance to the next textbox in the series using SetFocus. It works great but...... the cursor is not (setfocus vertical line flash) is not easy to see, I'd...