highlight rows vba

need help with vba find cell contain "NCAG" and highlight row until the cell contain "Total Sales For" then delete the row that highlighted

Hi there, I have a VBA code that is working great for me thus far. I have it set up that if the drop down is selected as Testing, Passed, or Failed, it will highlight the entire row as yellow, green, or red. However, this color formatting will remain for the entire row even if I delete the...

Hello, I am working in Excel 2013 and trying to color rows of a used range automatically after column G (US column) or I (DS column) is sorted. Another user will be having to sort (sort either desc or asc, it will vary) between these 2 columns over and over and I need to rows to be colored...

I have a spreadsheet in which the first column contains category names in bold letters and sub-category names in regular letter. I would like to highlight in blue the whole row where the cells containing the category name in bold and the subcategory names in regular letters in green. The other...

Most of us know the 'trick' where we use Excel's Find -> Find All option, then press CTRL-A to select all the result cells containing the search target. Then we exit the search dialogue and apply formatting to the cells (which remain selected). To highlight entire rows containing the selected...

I have some simple VBA that highlights the entire row if fields in a column match a certain criteria, however, I would now like the VBA to look at the cells in another column that have been highlighted and delete the row if the cell contains the same value above or below. See example below, rows...