Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) |