James thunderbolt
Member
Say on column A I have a list of dates, I would like to DIM the cell next to today's date as the range.
So if A1 is 18/05/2016 then the defined range (lets call this TODAYRANGE) should be B1, but, if A2 is 19/05/2016 then the defined range tomorrow should be B2 ?
Is this doable?
Thanks
JT
So if A1 is 18/05/2016 then the defined range (lets call this TODAYRANGE) should be B1, but, if A2 is 19/05/2016 then the defined range tomorrow should be B2 ?
Is this doable?
Thanks
JT