highlight cell

Greetings, I have a macro (which runs painfully slow) that highlights unique cells between two ranges on different worksheets. I've been trying to add a message box that displays the number of unique cells but the method below has not been working: Sub HighlightDuplicates()...

Hello everyone, I've been racking my brain trying to figure this out. I have a census list, containing over 1000+ names. What I need, is a CF formula that will allow me to highlight text entered in a specific way. For example, if cell G2 contains the name "John B Smith", and G3 contains "Jane...

Hey all! I need help with some Conditional formatting. Here is what I got: Here is what I need: In short: If any employees in the "Employee List" are listed as Terminated ("Terminated Employees"), format those employees with red text. Or if you prefer: If ANY of cells $A$2:$C$5 match...

Hi All, I'm having an issue with some vba coding, I basically want it to highlight the cells in column p where the (current date - 3 days) rule applies. I am currently getting the whole row that highlights rather than the singular cell in column p. Code is shown below:- Sub HighlightDates()...

Hope someone can help, i have a sheet of order numbers that we use. e.g #1 to #320. this is across a whole sheet starting from Cell A2>G41 cascading downwards. I want to assign a checkbox next to each numbered cell, that when ticked will highlight the numbered cell and colour it green with red...

I'm looking to apply a cell highlight to all intersections where the row and column heading match. The data set will be a pivot table, but if this prohibits the application of formatting I can work with a table. Solution needs to be Excel 2007 compatible. An example of what I'm looking for...

Hey, Overview and goal: I'm looking for something that will help with commission approvals. Rather than going through and highlighting the cell that is being paid, I'd like it to automatically do that depending on the values in 2 cells. I'd like to highlight the lowest cell in a column (only 2...

Hi, I am currently use the 64 bit version of excel 2013. I tried using a vlookup for which i had to go to another sheet. The cells in the reference sheet just did not highlight the way they used to when i was on a 32 bit! No matter where i clicked on the sheet, it did not show anything. Please...

Below is my current Macro, and I could use some help with a few things. 1) For each F,G,H,I,J end sample ranges that use the formulas, I want a Medium thickness, continuous, top Border. Also, I would like the cell to be highlighted yellow. 2) Sometimes the J column formula will show up as...

Hi I am trying to create conditional formatting in Excel 2007 to highlight a cell based on its value in comparison to today's date. I have a cell (B1) which has a value of TODAY(). I want to express conditional formatting for a range of cells (B4:J90) which all have a date value in them. I...

Need to compare Col D's % value to Col F's % value, if they do not match, highlight the cell in Col F yellow using vba. Ideas?

Hello, I need to copy a set of conditions for highlighting cells across several columns whereby the cell values changes as well. See below an example: My conditions are: - If equal to max value highlight green - If equal to min value highlight red Now I need to copy across several columns...

Hello. The SOC (start of care) is the date in which my company starts servicing a client, and these clients are required to have a F2F document signed no earlier than 60 days BEFORE the SOC and no later than 30 days AFTER SOC. So if the F2F date falls outside of that range, I need the cell for...

I have searched over the net and on this site but none fits my needs. I have datebase on inventory consisting of several tabs, what i want to do is have a macro to find a match and highlight the active cell if a match is found on different sheets. Only the active cell will be highlighted if...