I only just discovered the possibility of conditional formatting.
Apparently, only three formatting rules can be set. What is the way around
this limitation if I want to make it more complex. Some formula I guess?
Thanks.
Özcan ELMALI - 20 Mar 2007 12:32 GMT
you must use Excel 2007 :) no limitation Conditional Formatting
or may be write a macro code
Ozcan ELMALI
> I only just discovered the possibility of conditional formatting.
> Apparently, only three formatting rules can be set. What is the way around
> this limitation if I want to make it more complex. Some formula I guess?
> Thanks.
awrex - 20 Mar 2007 23:39 GMT
Try here...
http://www.mvps.org/dmcritchie/excel/condfmt.htm
or...
http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm
> I only just discovered the possibility of conditional formatting.
> Apparently, only three formatting rules can be set. What is the way around
> this limitation if I want to make it more complex. Some formula I guess?
> Thanks.
jim3975 - 21 Mar 2007 09:30 GMT
Great! Thanks a lot.
> Try here...
> http://www.mvps.org/dmcritchie/excel/condfmt.htm
[quoted text clipped - 6 lines]
>> this limitation if I want to make it more complex. Some formula I guess?
>> Thanks.