Hi All,
I could use some help with this particular challenge I'm facing.
Below is some sample data
<tbody>
</tbody>
The report pulls through the information in this ungodly format. The main person I'm interested in is Gina.
Each line represents a cost for a bus route from LON-EGG and the respective ticket prices for each time for each date.
The information I'm interested in highlighting through conditional formatting would be any price that Gina has set that is less or more than a £2 difference than (this is where it gets complicated) for any ticket Richard has set only if there is an hour or less between flights.
So for this particular example, I would really only want to know about Gina's 10:00, 12:30 and 14:30 tickets, should they differ from any ticket within an hour of them that has a £2 or more difference.
The reason I wouldn't be interested in the 07:30 ticket is because the next ticket isn't until 09:00 which is 1:30 later.
Any of Gina's prices that differ by £2 or more from any flight within an hour of one of Richards should show up red.
Thanks for your help - there is an ENORMOUS amount of data I need to work through so to flag them up red would be doing me a massive favor but I am completely stumped!!
Thanks
Rashie.
I could use some help with this particular challenge I'm facing.
Below is some sample data
Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | ||||
Market | Departure Time | CXR & FlightNumber | Name | 24 11 2016 | 25 11 2016 | 26 11 2016 | 27 11 2016 | 28 11 2016 | 29 11 2016 | 30 11 2016 | 01 12 2016 |
LONEGG | 07:30 | gina | £7.00 | £11.20 | £7.50 | £8.40 | £7.00 | £7.00 | £84.00 | £8.40 | |
LONEGG | 09:00 | richard | £125.00 | £10.00 | £12.00 | £125.00 | £6.00 | £6.00 | £6.00 | £6.00 | |
LONEGG | 10:00 | gina | £24.70 | £8.40 | £9.20 | £2.00 | £11.20 | £9.00 | £84.00 | £4.00 | |
LONEGG | 12:00 | richard | £125.00 | £15.00 | £12.00 | £20.00 | £10.00 | £7.00 | £7.00 | £6.00 | |
LONEGG | 12:30 | gina | £24.70 | £13.30 | £9.00 | £24.70 | £11.20 | £9.20 | £84.00 | £8.40 | |
LONEGG | 14:30 | gina | £24.70 | £8.40 | £7.00 | £25.50 | £9.20 | £4.00 | £75.00 | £7.00 | |
LONEGG | 15:00 | richard | £15.00 | £15.00 | £10.00 | £20.00 | £10.00 | £7.00 | £7.00 | £7.00 |
<tbody>
</tbody>
The report pulls through the information in this ungodly format. The main person I'm interested in is Gina.
Each line represents a cost for a bus route from LON-EGG and the respective ticket prices for each time for each date.
The information I'm interested in highlighting through conditional formatting would be any price that Gina has set that is less or more than a £2 difference than (this is where it gets complicated) for any ticket Richard has set only if there is an hour or less between flights.
So for this particular example, I would really only want to know about Gina's 10:00, 12:30 and 14:30 tickets, should they differ from any ticket within an hour of them that has a £2 or more difference.
The reason I wouldn't be interested in the 07:30 ticket is because the next ticket isn't until 09:00 which is 1:30 later.
Any of Gina's prices that differ by £2 or more from any flight within an hour of one of Richards should show up red.
Thanks for your help - there is an ENORMOUS amount of data I need to work through so to flag them up red would be doing me a massive favor but I am completely stumped!!
Thanks
Rashie.