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 Sturman@discussions.microsoft.com> wrote in message 
news:F6ECB6A0-6439-42A6-B32D-F685E0E92443@microsoft.com...
>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
> 
> 
>