Hi Adrian See if this is what you want. Sunny
Hi mey Please attach some samples and the expected result.
Hi Nik My apologies, I totally misunderstood your request .Thanks Catalin for clarifying it. Catalin's example is the easiest to implement but i...
Hi Craig There is no attachment.
Hi Nik Maybe I misunderstood your question as you did mention "I'd like to colour the rows based on when the value in column A changes." If y...
Hi Krishna Maybe you can consider using a Pivot Table. Sunny
Hi Nik The macro is in the Sheet1 module. It uses a worksheet change event to trigger the macro. It is set to run only if one cell in column A i...
Hi CK_One Try this I have created a dynamic range named MyList and used it in your DV. Change to suit your needs. Hope this helps. Sunn...
Hi Nik See if this is what you are looking for. It contains a macro, so make you enable macros. It will generate random colours whenever a cell ...
Try this. You can even use (ignoring the TIME() function) =TEXT($B$1,"hh:mm:ss")>"00:03:30" =TEXT($B$1,"hh:mm:ss")="00:03:30" =TEXT($B$...
Hi Julian You can put this code in the TulList worksheet module. Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Application...
Hi mey I have a 2nd method for you. Sunny
Hi mey There may be a better solution but you can try this for now. I would prefer you to include an attachment the next time as it will be easi...
Hi mey I think maybe your teacher wanted the years of service. Refer attachment. Sunny
No idea about the Seniority as you did not show how to classify that in your question.