CF
FormulaIs: =OR(A1="a",A1="f",A1="p")

Repeat for other conditions

HTH

"Dave" wrote:

I have 7 values ie a, f, p, s ,t n and sl which are used within the
worksheet, i want to apply a pattern colour to the cell which a,f and p use
whilst a different colour for t,n and sl and another for n. As conditional
formatting gives only 3 conditionals I can not use cell values ="a" etc. I
have tried formulas such as OR but can not get to work. Any ideas please.
--
Dave
Thanks