Afternoon.

I have set up a spreadsheet to monitor my golf scores, now I know there is a function that says if the number is below x show the cell as this colour and if the number is above y show the cell as this colour.
I want to use it to easily show whether above or below par for 18 holes after handicap has been deducted. ie less than 70 green. 70 blue and 71 or above red.

anybody undrestand what I am on about and know how to do it?



cheers

 

Coinditional formatting - press f1 ( help ) and type in conditional formatting.

If you cant do it, give me a shout.

ps Its even nicer nd easier on office 2007

 

Brilliant. cheers.

Done it, knew it was there somewhere just couldnt remember where or find it!

thanks