use more than 4 condition in cf without using macro

[Montu]

in conditional format, there is only 3 condition. is there any way to increse
condition in conditional format. because I need more than 3 condition. help me

 

[ryguy7272]

This question comes up on the DGs every once in a while. It's amazing what a
simple search will reveal:

http://www.microsoft.com/office/com...=en-us-excel&lang=en&cr=US&sloc=en-us&m=1&p=1

http://www.microsoft.com/office/com...=en-us-excel&lang=en&cr=US&sloc=en-us&m=1&p=1

Hope that helps,
Ryan--

 

[Bernard Liengme]

If there were a way, then 3 would not be the limit in pre-2007 versions.
Only VBA can help you
best wishes

 

[Bob Umlas, Excel MVP]

the guy wanted a non-macro solution. Bernie got it right!