Results 1 to 5 of 5

Thread: excel question

  
  1. #1
    Status
    Offline
    A5TRA 59ORT's Avatar
    AOC Gold Member
    Join Date
    Mar 2004
    Posts
    4,202
    Mentioned in
    0 Post(s)
    Quoted
    1 Post(s)

    excel question

    is it possible to get excel to set the cell background colour programtically??

    basically i want to do a logic function (i can do all the logic functions) on a cell and if it is ture set the background colour to red for example and if it is false set it to green for example.

    is this possible with excel??

    i am using office 200 BTW if that makes any odds.

    cheers,

  2. #2
    Status
    Offline
    Sploodge's Avatar
    BAFPCITS
    Join Date
    Jul 2005
    Posts
    6,522
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    Yeb, its under the format option and called "Conditional Formatting"..


    Mr Sploodge, Accept No Imitations!

  3. #3
    Status
    Offline
    A5TRA 59ORT's Avatar
    AOC Gold Member
    Join Date
    Mar 2004
    Posts
    4,202
    Mentioned in
    0 Post(s)
    Quoted
    1 Post(s)
    cheers mate but is there anyway i can write the commands/formula for it so that i can drag the "formula" down without having to set each cell indviually??

    also i was hoping to change the backgorund colour of a cell depending on the value of a different cell rather than the contents of itself.

  4. #4
    Status
    Offline
    Sploodge's Avatar
    BAFPCITS
    Join Date
    Jul 2005
    Posts
    6,522
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    have a look at the Google results for Conditional Fromatting - http://www.google.co.uk/search?hl=en...nG=Search&meta=
    Loads of stuff you can do with this option..
    Mr Sploodge, Accept No Imitations!

  5. #5
    Status
    Offline
    A5TRA 59ORT's Avatar
    AOC Gold Member
    Join Date
    Mar 2004
    Posts
    4,202
    Mentioned in
    0 Post(s)
    Quoted
    1 Post(s)
    cheers mate got it all sorted now

Similar Threads

  1. Need some Excel help...
    By x1nick in forum Chit Chat and a Warm Welcome!
    Replies: 0
    Last Post: 18-06-2008, 20:08
  2. Excel Help
    By Blue Coupe in forum Chit Chat and a Warm Welcome!
    Replies: 0
    Last Post: 12-09-2005, 13:30

Posting Permissions

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