Hopefully there is an easy fix for this! I 'upgraded' to Excel 2013 today and I have noticed that when I am doing a SUM or SUMIF etc in one sheet or workbook where the array is in a different tab or workbook, Excel no longer highlights the cells I am selecting, so it is relatively...
Have a data sheet containing clients and the dates these clients contacted the company. From the column listing dates the clients were established, I'm trying to get any of these dates that are 7 days or older to highlight in red..brain sore and just have not been able to figure it out...
I have a spreasheet representing a kind of store in a industry.
There are in this room several boxes (each box is a cell) with different colors.
Is there a possibility to put the cursor over one box of a certain color and the
others boxes which have those same colors be highlighted...
I am looking to search a worksheet for multiple strings and highlight each cell that contains one of those strings. For example, if the sheet has a column named color and each row has a color (e.g., red, green, blue) I would like the macro to either take multiple strings such as "blue", "red"...
I have an excel sheet for recording the results from measurements made on round material.
What I want is to have the conditional formatting so that if they have more than the allowed difference in a column they are highlighted red.
Allowed difference is 0.06 so the cells with...
I have two excel sheets and i need to compare the rows and highlight them, the problem is the rows are random and even the columns are not even. Below is the sample data
Test1 test2 test3 test4
Key 2 3 4
Test1 test2 test3...
I have created some buttons in my excel sheet to highlight cells when clicked. However, I also want to protect the document so that only certain cells can be modified. When I protect the document the buttons no longer work even though the specified cells aren't locked. I'm sure it is just some...
I'm working on a job booking system and I'm looking to create an if statement to highlight cells that have gone past the expected finishing times.
In the 'D' collumn I have the date the job is expected to finish as DD/MM/YYYY, and in 'K' collumn I have a similar set up that people...
I inherited an Excel 2010 workbook that is utilized to import in another excel data feed that is extracted from online source daily. Once imported this .xlsm workbook does several things, custom columns, several sorts, conditional formatting, etc. It currently highlights all rows that have a...
Real easy question... Cell C10 has the favorite team. Cell D10 has the underdog team. What I'd like is a macro that will test whether or not Cell C10 is highlighted (any color). If so, Cell E10 should automatically be "1", if not highlighted, E10 is "2".
Hope this is straight forward enough...
Fellow Forum Members,
I have a lot of cells containing numbers and with dark colored highlights applied that makes the numbers hard to read. I also have other cells with colors like Yellow that is easy to read the black colored fonts.
What conditional formula can I use to change Black Font...
Hello excel experts!
I am using excel 2007 and I'm trying to figure out how to highlight a subsequent cell when the one before it has an "x" entered into it...and I am completely stuck! For example: when an "x" is entered into A1 then B2 (and only B2) is highlighted.
Although I'm fairly savvy...
Let me explain exactly what I'm trying to figure out. I am looking in every row starting in Columns P, Q and R. It will go to the next row below the first and see if those columns have the same exact value. If it doesn't it goes onto the next row. If it turns out that row 1...
I designed a pivot table and have the datas in percentage. So for each row, I have to highlight top 3 values (highest by individual row level) in different colors. Can someone help me with it?
Hello to all
I have the following table going down to 3000 rows
Hello to all,
I am truly stumped. I searched but couldn't come up with anything that works. I am trying to highlight a number of cells based on a count not values. In other words if A1 has a number 5. I would like A2:A6, next 5 cells, to automatically highlight. I would prefer something in VB...
I have some data shown below in a spreadsheet.
Each string (g, z, u*, b*...) is in its own cell.
I am trying to highlight the cells that has *.
I tried Conditional Formatting...
I would appreciate any help..
I have a list of words which I would like to know if column C contains each one of them in each cell, if it's true I would like to highlight the cell in red.
with conditional formatting I'm able to create one rule for one each each time..
I have a fairly large spreadsheet which I use for tracking progress, I have dates in columns D-G in two styles "good" i.e. Green and "bad" i.e. Red, I need a macro that will highlight cells with past dates that are considered "bad" as these should always be future dates. The cells that are...