Conditional formating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 18 Jun 2007 14:30 GMT

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.

Signature

Dave
Thanks

Reply to this Message

Toppers - 18 Jun 2007 14:50 GMT

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

Repeat for other conditions

HTH

> 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.

Reply to this Message

Max - 18 Jun 2007 14:51 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message