Conditional formating
 

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

Conditional formating
 

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

Conditional formating
 

OR should work fine

Try something like this as the CF's "Formula is"

Select col A, then apply it as

Cond1:
=OR(A1="a",A1="f",A1="p")
Format: Green

Cond2:
=OR(A1="t",A1="n",A1="sl")
Format: Red

Similarly for cond3
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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