highlights

Hello, I am looking if someone can make VBA that can highlights last rows in the column C:H as per data last data row column K:Q as per example below...

I use the Following Conditional Formula to highlight rows if multiple cells together are duplicated: =SUMPRODUCT((col_b=$B1)*(col_C=$C1)*(col_d=$d1)*(col_e=$e1))>=2 and it works fine except it highlights all instances not only 2nd or 3rd or more duplicates as intended I've tried countifs...

I have created a form with a macro to sort a list into a given order preferance. There is also a checkbox function that highlights a group of cells in a row based on true/false checks. When i sort - the check boxes move but conditional formatting does not. Thus you could check b3 and it...

I have a workbook to which I want to have a beforesave run in which I delete both comments and highlights, I have not been able to achieve it in the last few weeks, I've searched for possible solutions among other co workers, I was suggested the tracking system inside excel but this is a...

Hello, I am trying to find a way of making a cell become highlighted if any 2 or more cells within a selected range are greater than 0. For example if A1 and A3 are 2 and 4 respectively but A2 is blank or 0 then A4 will become highlighted with the total. Is this possible? Thanks

I've searched high and low and cannot find the precise macro needed. To make it as straight forward as possible: I need to compare "Sheet1" column "Serial Number" with "Sheet 2" column "Serial Number" If any serial numbers are found on both sheets, they should remain unchanged. If any serial...

Hey all, I want to take a color of cell and use that color to fill a range of corresponding cells in the same row as the cell fill color. I have already done conditional formatting to get a list of cells to be a bunch of different filled colors, but I'd now like to take each color and extend...