Thread: Golf scores
View Single Post
  #1  
Old May 29th, 2010, 01:49 PM posted to microsoft.public.excel.newusers
Pop Sturman
external usenet poster
 
Posts: 1
Default Golf scores

I am trying to change the cell colour depending on the input against the
actual Par .
ie Column A = the actual par for each hole, Column B is the actual score


if the input for cell B2 is greater than cell A1 the cell = Red
"""" """""" """" """ = to """ """ """" = Green
"""" """""" """""""" less """" """ """ """" = Purple

Many thanks