Hello all,
Im just looking for advice on how my work could be more easily read and followed by others.
Its basically calls coming in and calls ended by agents and the times they started and ended the calls.
Im thinking a colour option ive done example in column C23 C37 (although this needs to be conditional formatting - which im having trouble doing due to the blank gaps between calls)
As i said any advice on how the layout should look and help make it easier for the end user would be great!
I've done columns C:G for you, using conditional formatting. Is this what you had in mind?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi thank you for your reply, its the blanks between the Internal ACD Answered
and call ended that need filling also. ie C69:C72 would need to have colour.
OK, I know what you want. I'm not clear WHY you want it. taking that example, if C69-72 were coloured, it would look like Ron had taken an age over a call (it's about 10mins). It would look that way only because Jermaine had take a short call in between those times. There are plenty of other example where 5-6 minute calls only need 2 cells coloured, as there were no other calls started/stopped in the intervening time.
So what's the reasoning?
One way round it might be to change your INDEX:MATCH to make something appear in those empty boxes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks