#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Golf scores

I am trying to change the cell colour depending on the input against the
actual Par .
ie Column A = the actual par for each hole, Column B is the actual score


if the input for cell B2 is greater than cell A1 the cell = Red
"""" """""" """" """ = to """ """ """" = Green
"""" """""" """""""" less """" """ """ """" = Purple

Many thanks



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 793
Default Golf scores

Use conditional formatting...

See http://www.cpearson.com/excel/cformatting.htm

"Pop Sturman" wrote:

I am trying to change the cell colour depending on the input against the
actual Par .
ie Column A = the actual par for each hole, Column B is the actual score


if the input for cell B2 is greater than cell A1 the cell = Red
"""" """""" """" """ = to """ """ """" = Green
"""" """""" """""""" less """" """ """ """" = Purple

Many thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
golf handicap 4 of last 5 scores Golf.nut1 Excel Discussion (Misc queries) 15 April 3rd 08 06:11 AM
excel golf scores, how do I add the scores for all par 3's etc Golf Analyst Excel Worksheet Functions 2 November 24th 07 03:25 PM
Golf best 2 out of 4 scores Karl Excel Discussion (Misc queries) 7 October 23rd 06 09:11 PM
Golf Scores kevhatch Excel Discussion (Misc queries) 10 May 8th 06 01:45 AM
Golf Handicap Using Last 5 Scores Golf League Schedule Excel Worksheet Functions 5 May 13th 05 12:14 AM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"