Re: Highlight Rows with same date in different colour
Apologies, title should read different dates not same dates. I've solved it anyway. Inserted a new column and just used the following code:
=IF(J6=J7,K6,IF(K6=1,0,1))
Then just used conditional formatting on the 1 and 0.