HMM I based my whole program on colours....what now?
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

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

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.


  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com