Colouring cells
Colouring cells
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

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