Looking for a macro that will highlight Range C if it contains below Ticket Ranges.
ST388 - ST404
CR510 - CR528
What the macro should do -
If Range C contatins ticket ranges from ST388 to ST404 and CR510 to CR528, then,
Range C should get highlighted with RED color .
Option should be provided in the code to make changes to the Ticket Range and color.