highlight row

I have data currently in an Excel spreadsheet in Columns C:Q Columns are going to be added but Column C will always be the starting point with C6 being the first data cell. Row 5 has headings and no cell in the data area in row 5 is blank. Row 6 has data but there are cells which are blank. I...

I need to highlight any row that has any value in column P. I've tried using this formula- =$P1<>"" It did format the row but it also highlighted my colum headers as well which I have frozen at the top of the spreadsheet. How can I highlight the row without affecting my headers?

Hello Experts, I need help with a macro that cycles through one column ("Week-Ending Date") of a formatted table that users are updating each week to find unique values (e.g. "6/25/2016 or "7/9/2016") in that column and then highlighting the first row with that unique value up and through...

Hi, I am new so forgive any mistakes. I have a table from column B to column M and row 8 to row 47. What I would like is to highlight the row in that range if i selected a cell in that row. So for example if I select M8, then cells B8:M8 would be highlighted, but if I was to select N8 or A1...

I would like to have Excel 2003 be able to highlight the row if there is data in certain columns. Specifically if there is a number greater than zero. For example the following could work...

Hey everyone, I'm pretty new to VBA but I think it's a great tool for parsing data which is what I've been doing a lot at work lately. Utilizing Excel 2009, I am trying to look for a solution that will allow me to compare a column which contains a list of filenames i.e. "832423.wav" to a...