the conditional formatting wasn't to bad to work out, however i couldn't get it to work with an expanding range for additional dates. So i cheated ...
Hi Steven The attached is a .xlsx so not a macro workbook and therefore no code in it. You are using A to AF as the data dump and AH as the crit...
You could just do this in a formula if it helps - i have used this so many times in my work. =REPT("0",6-LEN(A1))&A1 Purfleet
Morining Could you add an example workbook so that we do not have to recreate the data and to ensure that we understand what we are looking at? ...
Hi Cristina As a first attempt I have written a small macro that when press will check the dates in row 6 and hide anything that is older than toda...
I am sure there is a funky, quicker way with power query, but this is a formula based answer Copy the data in Column A then paste and remove duplic...
You want to add more colours with more names? This is where is gets difficult with your data if you want to add more columns =IFERROR(LEFT(CELL(...
Probably a couple of ways to do it and some will depend on what version of excel you have. The way that should work in all version is the nested if...
I think it was the order of the sum that caused the problem. =IF(G13="","",IF(G13>TIME(HOUR("12:00"),MINUTE("0"),SECOND("0")),(G13-TIME(HOUR("12...
Hi Jay A couple of questions You don't say where you want the formula to appear? Are the numbers in columns Q to T supposed to be the percentage...
Hi Ziggy Can you please add a sample workbook so we don't have to recreate the data? I also ensures that we have got the right format etc Purfl...
No problems - good luck with the job. Will be trying to get up to Skeggy with the dogs at some point
I think you just need to sum N13&N14 instead of n13 in the above formula So =IF(H15-N13>48,H15-N13-48,"") becomes =IF(H15-SUM(N13:O14)>48...
Can you add a sample workbook, so we can see how the code is interacting with the worksheets? There is a lot of code in there that is redundant fro...
Hi Rafi Rather than find the cells that can error wouldn't it just be better & more reliable to format the entire column as general as a matter...