i have been asked to show what areas are in use during different times. i have taken the times out of the cells and converted them into time format and used column "F" to show true of false when i enter the time range.
the question is how can i stop the shapes being shown if it is not within the time.
at the moment it if the time is after the range it will not show which is good. but if the start / end time has expired it still shows.