highlight cells

Hello, We are working on a warehouse layout, which has huge floorspace, using excel spreadsheet. the layout scale is good enough to represent each square cell as One Square foot. We're trying to measure certain areas by highlighting group of cells, no matter if they contain values or blank...

I am creating a spreadsheet for my job and it would be really helpful if somebody knew a code or any way to implement this into my spreadsheet. Thank you, Chris

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...

Hello, I have 4 columns with data H, I, J and K. I need to write a macro that will search through H, starting at H14 and look for a single 0 (zero) in all cells with data in column H starting from H14. This is where I get a bit stuck as I don't know how to add IF functions through arrays. So...

Hi all, 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...

Hi all, 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...

Hi all, 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"...

Hi all, 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. Example: Allowed difference is 0.06 so the cells with...

Hello Guys, 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 Ex: Sheet 1 Members Test1 test2 test3 test4 Key 2 3 4 Sheet2 Members 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...

Hi All, 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...

My current data sheet looks as under; <tbody> Row ColumnK ColumnL ColumnM ColumnN ColumnO 3 21-Sep-2013 4 27-Sep-2013 5 03-Oct-2013 6 11-Oct-2013 7 23-Oct-2013 8 17-Sep-2013 9 01-Oct-2013 10 08-Oct-2013 11 23-Oct-2013 12...

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...

Hello Everybody, 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...

Hi, 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? <tbody> SUBJECT MARK1 MARK2 MARK3 MARK4 SUB1 86 67 12 76 SUB2 45 56 35 97...

Hello to all I have the following table going down to 3000 rows <TBODY> 01/01/2013</SPAN> 6</SPAN> 17</SPAN> 21</SPAN> 26</SPAN> 35</SPAN> 01/01/2013</SPAN> 1</SPAN> 2</SPAN> 15</SPAN> 17</SPAN> 20</SPAN> 02/01/2013</SPAN> 7</SPAN> 10</SPAN> 15</SPAN> 25</SPAN> 31</SPAN>...