Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Colouring cells

  1. #1
    Guest

    Default

    How can I colour a cell with a different colour depending on the value selected from a drop down box?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Belgrade, Yugoslavia
    Posts
    156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    You can use Conditional Formatting.
    "Format"-"Conditional Formmating"
    Put Cell value to be the one from drop down list, and in Format go to patterns and select colour.
    The bad thing is that you can have only three conditions, meaning that you can have only three different numbers from drop down list.
    Myybe someone can help you with some VBA formula.
    Sax

Some videos you may like

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
  •