Cond format more than 3 colours

[keith]

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

 

[Max]

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.CFPlus.Download.html

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

 

[Max]

Typo in line:

... check out Bob Phillip's:

should read as:

... check out Bob Phillips':

Sorry about that, Bob <g>

 

[Bob Phillips]

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)