Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2008
    Location
    Buxton, Derbyshire, England
    Posts
    22
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Conditional Formatting

    I play golf and want a spreadsheet that will automatically highlight par; one over and one under in different colours. For example if Hole 1 is a par 4 when I enter my score I want 4 to be highlighted red; 5, blue and 3 yellow all other numbers default black. I think conditional formatting will do this but what is the easiest way? Can I do it by having a constant column with all the correct par scores shown and comparing each entry with that rather than having to go through the process for each hole? In other words is there a formula that will, on each hole, compare my score with the par for each hole in the "constant column" and highlight my scores which equal it or are one over or under?
    I hope this is clear???

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Put the par in one column and what you show in another.
    Then, select what you shot (all rows) and use conditional formatting.

    Sample attached. (reposted attached to reflect hole-by-hole)
    Hole-by-hole used three versions of this: =IF(AND(B10=4,B11=3),1,0)

    Kevin
    Attached Files Attached Files
    Last edited by kweaver; 2013-05-11 at 12:35.

  3. The Following User Says Thank You to kweaver For This Useful Post:

    eromittal (2013-05-11)

  4. #3
    New Lounger
    Join Date
    Sep 2008
    Location
    Buxton, Derbyshire, England
    Posts
    22
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Many thanks - great but how on earth would an Excel Novice work this out!!??

  5. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Well, good question. Now you're no longer a novice...
    You have to play around with Conditional Formatting, experiment, test, etc., and you'll get the hang of it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •