conditional format (different colors needed)

[supermario]

Hi
I have a golf spreadsheet. I want the par scores displayed in
blue and the birdie scores displayed in red.
eg on a par 4 hole any 3's would be in red, any 4's would
be in blue
thanks
supermari

 

[Max]

Assume the set-up below is in cols A to C,
data from row2 down

Hole Par Score
1___3
2___4
3___4
etc (till Hole 18 ?)

Col C (Score) is where you'd apply
the conditional formatting (CF)

Select C2:C19

Click Format > Conditional Formatting

In the settings tab, make the settings as:

For Condition 1 (For Score = Birdie*):
Formula Is | =$C2=$B2-1
Click Format button > Font tab > Red & bold > OK
[*Birdie = Par -1]

Click Add >> (adds 2nd condition)

For Condition 2 (For Score = Par):
Formula Is | =$C2=$B2
Click Format button > Font tab > Blue & bold > OK

Click OK at the main dialog
--
Test the CF out by entering
some score figures in C2:C19 !

Scores higher than par or lower than birdie
will remain "unformatted"

 

[Max]

Oops, the line:

In the settings tab, make the settings as:

should read simply as "Make the settings as:"
(there's no settings tab in CF <g>)

 

[supermario]

Hi
this is the layout I am working with
Can you restate your solution using this template?
thanks
supermario

hole 1 2 3 4 5 6 7 8 9
par 4 3 4 5 3 4 4 4 5
score1 5 3 3 5 4 5 3 3 5
score2 6 4 5 4 4 4 3 4

 

[Max]

For the layout posted, assumed to be in A1:J4, try this:

Select B3:J4

Click Format > Conditional Formatting

In the settings tab, make the settings as:

For Condition 1 (For Score = Birdie*):
Formula Is | =B3=B$2-1
Click Format button > Font tab > Red & bold > OK
[*Birdie = Par -1]

Click Add >> (adds 2nd condition)

For Condition 2 (For Score = Par):
Formula Is | =B3=B$2
Click Format button > Font tab > Blue & bold > OK

Click OK at the main dialog