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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…