Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Colour of Cells (Excel '97)

    Does anyone know how to change the colour of a cell using a formula? I.e. Place an IF formula in a cell to check text in another cell and change the cells colour accordingly!

    Thanks
    Jamie

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Changing Colour of Cells (Excel '97)

    Jukebox

    Check the Conditional Formatting under the Format menu.

    If you need examples let us know.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Oct 2001
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Colour of Cells (Excel '97)

    I could do it with conditional formatting but it only allows for three different formats to be applied, i need at least 5, thats why i want to do it by using the IF formula because i could nest up to 7 of them!

    Jamie

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Changing Colour of Cells (Excel '97)

    Jukebox

    I am not sure you can do it with an If formula. You see a Formula may change the value of the cell, but not its formatting. This is why MS gave us the Conditional Formatting...

    Try VBA if you can.

    Again if you need any examples we'll give them to you.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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