excel problem highlighting cell or text in cell

  widdy 19:46 28 Oct 13

I have a scoreboard program that updates a gymnasts position within a range to show their current position, after entering each score i.e.1st, 2nd or 3rd Is there a way of highlighting the cell or the text colour so that it can be located more easily? The formula used for updating the position is =IF(G3=0,"",RANK(G3,G$3:G$11)) assuming gymnasts in the rang g3 to g11 i.e. 9 gymnasts all help most welcome Thanks

  Zak 19:58 28 Oct 13

Try conditional formatting. If this does not help, please provide more details of the spreadsheet content please.

  widdy 08:16 29 Oct 13

Yes all ok, found solution just after I posted the query Many thanks

  Fermat's Theorem 17:55 06 Nov 13


I'm interested in knowing the solution you found to your problem. Many thanks :-)

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch