HMM I based my whole program on colours....what now?

[friso]

For an excel program i use conditional formatting colours (three) for displaying a calendar. HOWEVER now i need to display a fourth colour through conditional formatting.

Excel only gives three conditional formatting options, and my macro says 'range out of bounce'

Couldn't find this on the forum guys, please help me out.

[Ivan F Moala]

On 2002-04-15 00:27, friso wrote:
For an excel program i use conditional formatting colours (three) for displaying a calendar. HOWEVER now i need to display a fourth colour through conditional formatting.

Excel only gives three conditional formatting options, and my macro says 'range out of bounce'

Couldn't find this on the forum guys, please help me out.

You will have to use VBA to do this via one
of the event handlers.
I'm sure this has been covered before.....
If unsure then post the specifics of your
CF and addresses you need to monitor.

[eliW]

On 2002-04-15 00:27, friso wrote:
For an excel program i use conditional formatting colours (three) for displaying a calendar. HOWEVER now i need to display a fourth colour through conditional formatting.

Excel only gives three conditional formatting options, and my macro says 'range out of bounce'

Couldn't find this on the forum guys, please help me out.

friso,
Instead of using conditional formatting you can run a simple macro which will check your cells and paint them in as many colors you wish.
Of course it is not interactive and you'll have to run your macro for every change.
Eli

[friso]

hmm too bad i was hoping there was a method to get a fourth formula in there...