Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting (excel 2000)

    Dear Experts,

    I would like to highlight the cell in a range with a specific colour if the cell meets a certain condition. Unfortunately I can

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (excel 2000)

    You can use Data Validation to provide the drop down lists in the cells for the selections that you have described. You should also be able to use the worksheet change event to do the color highlighting that you want. Your description does not contain quite enough detail for me to do the code.
    Legare Coleman

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting (excel 2000)

    See if the attached example (based on Legare's suggestions) does what you want. The code is in the worksheet module.
    Attached Files Attached Files

  4. #4
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (excel 2000)

    Hans

    This is exactly what I hoped for. Thank you very much for your solution.

    Best regards

    aussiehans

Posting Permissions

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