+ Reply to Thread
Results 1 to 4 of 4

Too many Conditions for Conditional Formatting

  1. #1
    Registered User
    Join Date
    02-06-2006
    Posts
    13

    Unhappy Too many Conditions for Conditional Formatting

    Hi all,

    I'm trying to simply colour a range of cells when data is entered in to them for example:

    When "Dr B" is entered I would like the cell to be automatically coloured green.

    I know this can be done using conditional formatting but I have 5 different Dr's to colour in!! is there any way of adding more conditions????? I have had a go at VBA but as I am completely new to it I'm running out of 1) time and 2) patience!

    Any help would be gracefully accepted, I wouldn't even say no to a prod in the right direction.

    yours hopefully

    Alex
    x

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    What are your precise conditions? You could google this, it's quite a common request. Alternatively, post details here and no doubt somebody will help.

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon alexandra60

    Do you have access to XL2007 - I beleive this does away with the three condition limit that users constantly moan about.

    If you don't then there is a free add-in available that you can use that will give you up to 30 possible conditions. You can download it from here :
    http://www.xldynamic.com/source/xld.....Download.html

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Registered User
    Join Date
    02-06-2006
    Posts
    13

    Talking

    I google'd it!

    Thanx for the advice, all sorted now :-)



    A very happy Alex
    x

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1