#conditionalformat

Hi, I'm new to VBA and would greatly appreciate your help with this query I have a sheet that looks like this I would like to add column titles in the highlighted cells based on the first left column that is not blank. For e.g. D1 will have the title -> C2+"_1" a.k.a "Column2_1" and cell E1...

Hello, I use excel 2010 and I have these two formulas, =AND(NOT($K2= "DHD - On hold per Client"),$M2<now(),$n2>=0,</now(),$n2>$N2>=0<now(),$n2>)</now(),$n2> =IF(AND(NOT($K2="DHD - On hold per Client"),$N2>=0,NOW()>$M2),1,0) I can use either to help me highlight overdue assignments. I have...

Hello, so, I have to download a report with multiple jobs statuses, then further I have to filter by different criteria. I have certain formulas that helps me highlight the table by different criteria already while time is of the essence for me. I was wondering if i could set up a blank...

hello, I am using 2010 excel and I really need help with figuring out a formula for 3 conditions that highlights an entire row (each representing different status of a maintenance job) in a table format. I am trying to highlight the jobs in 3 different colors. The table Data A2 to R44, row 1...