Search results

haha if I leave they are screwed! No one understands my macros and our team need them for about 90% of what we do!

I bloody love what you can do with excel and bloomberg. I make things just for fun sometimes!

I have never been on a training course, it has been all google and getting myhands dirty.

Macros literally save me about 4 hours work a day :eek:

Completely agree, index match has saved me hours in loading. When you are dealing with 420k rows vlookup just doesnt cut it.

I think what you're asking is a way of higlighting the batsman was not out but you dont want a column that says out or not out? correct?

Haha I build financial models and macros for a living...

What's the identifier for him not being out. Sorry could you explain a bit clearer?

Uh oh! We've got a geek off!

See at the top on the home tab there will be a thing that says conditional formatting Clcik that then click on highlight cells rule. Then click on Text that contains. Then type in time or out of time and then apply the colour from the drop down selection on the right.

Should do some conditional formatting too to really spice it up. Make it so that if it is in time the cell highlights green and when its not it highlights red...

Beat me to it!

=IF(B2=>A2,"in time","out of time")