Specifying multiple conditions in a conditional format

[Mr_bikahs]

Hello all,

I was wondering whether it is possible to specify multiple conditions for a conditional format in Excel 2007. More specifically, having a "OR" clause in the conditions

So as an example, to turn a cell blue, cell must contain "Peter" OR "Daniel" OR "Matthew".

Is it possible to do such a thing?

Many thanks in advance.

 

[VoG]

Try the Use a formula... option and

=OR(A1="Peter",A1="Daniel",A1="Matthew")

 

[Mr_bikahs]

Sorry late reply, just came back to this today.

Thanks VoG, works a charm!