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

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"Pop Sturman" <Pop wrote in message
...
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

Use conditional formatting...

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

"Pop Sturman" wrote:

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