skins on spreadsheet for a tournament

  • Thread starter Thread starter Lynn
  • Start date Start date
Lynn said:
What formula can I use to get less than par on a hole to be a colored text?
Click to expand...

Conditional format. Par scores in B3:B21, Scores C3:C21.
Select C2:C21, conditional format C2 is equal to B2-1 and format the text as
required.

Add more formats for B2-2 and B2-3

regards
Peter
 
Im sorry i don't have a conditional in "format" or formula ,
Holes 1 2 3 4 5 6 7
Par 5 4 4 4 3 5 4
judy, lou 4 5 4 3 4 4
lynn, mary 5 4 4 2 4 4 5
this is an example of part of spreadsheet
 
Assuming what you posted is within A1:H4
where the par line is in row2,
individual scores in row3 down

Select B3:H4 (with B3 active), then apply CF using
Formula Is: =AND(B3<B$2,B3<>"")
Format the font to taste, Ok out
--
Max
Singapore
http://savefile.com/projects/236895
Files: 352, Subscribers: 53, Downloads: 15,500
xdemechanik
 
Back
Top