Golf scores

[Pop Sturman]

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

 

[T. Valko]

What version of Excel are you using?

 

[Sheeloo]

Use conditional formatting...

See http://www.cpearson.com/excel/cformatting.htm