Comments:
Regarding your question about conditional formatting, the maximum number of conditions to which you can apply conditional formatting is three.
The only way that you can get around this limitation is to write a macro which would apply the types of formatting you would want. You would most likely run the macro to apply the formatting using the Calculate worksheet event. So each time the worksheet calculated it would run your macro which would move through specific cells and apply the formatting according to the conditions which existed when the worksheet calculated.
|
