excel help
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