Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    changing cell color on its value...

    Hi there... I was just wondering if anyone could tell me how to do this...
    One of the people in my department does a lot of work in Excel and he wants a selected number of cells to change colour if the value in the cell is not zero... The value in these cells is determined by formulas elsewhere on the worksheet... He'd like any of these select set of cells that isn't zero after calc's, to show up red... Sounds like it should be easy, but I've never programmed in Excel... Can someone help?

    Oh ya... and he's using Office '97... (almost forgot)

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: changing cell color on its value...

    Select Format>Conditional Formatting...

    Once you set your specified condition, click on the Format button and set the colour to red.

    I use XL2000 but if my memory serves me XL97 uses the same method for conditional formatting.

    Tony

  3. #3
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing cell color on its value...

    Works perfectly Tony... Thanks a million!! [img]/w3timages/icons/kiss.gif[/img]

Posting Permissions

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