What formula can I use to get less than par on a hole to be a colored text?

"Lynn" wrote:

> What formula can I use to get less than par on a hole to be a colored text?

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


"Billy Liddel" wrote:

>
>
> "Lynn" wrote:
>
> > What formula can I use to get less than par on a hole to be a colored text?
>
> 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

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
---
"Lynn" wrote:
> 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