Can anyone tell me how I could change the colour of a cell based on a 10 line
aguement? as conditional formating will only allow three conditions

"keith" wrote:
Can anyone tell me how I could change the colour of a cell based on a 10 line
argument? as conditional formating will only allow three conditions

You might want to check out Bob Phillip's:
CFPlus - Extended Conditional Formatter, at his:
http://www.xldynamic.com/source/xld.....Download.html

Believe it can handle, quote:
Multiple Conditional Formats, up to 30 in total for any range of cells

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

Typo in line:
... check out Bob Phillip's:

should read as:
... check out Bob Phillips':

Sorry about that, Bob <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

s'alright Max, at least you gave me a double l <vbg

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Max" wrote in message
...
Typo in line:
... check out Bob Phillip's:

should read as:
... check out Bob Phillips':

Sorry about that, Bob <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---