Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Cell Color

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to have a cell (E16) change to green if cells E5-15 are >5 or red if E5-15 are < .5 That's the general situation. This is my first post so I apologize in advance. ~tb

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-14 11:14, Callao wrote:
    I'm trying to have a cell (E16) change to green if cells E5-15 are >5 or red if E5-15 are < .5 That's the general situation. This is my first post so I apologize in advance. ~tb
    Use Format|Conditional Formatting.

    By the way: Is

    E5-15 ===> E5:E15 ?


  3. #3
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-14 11:14, Callao wrote:
    I'm trying to have a cell (E16) change to green if cells E5-15 are >5 or red if E5-15 are < .5 That's the general situation. This is my first post so I apologize in advance. ~tb
    Please be more specific. Do you want the color of E16 to be based on the sum of E5 through E16, any value in that range, or all values in that range. (sounds like conditional formatting)

    [ This Message was edited by: Al Chara on 2002-03-14 11:23 ]

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes I mean E5:E15, sorry. and yes the sum of those. Basically I'm trying to flag a cell if the amounts are > or < a certain amount. thanks

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dope!!! Thanks so much!!! That works great.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Click on Format-Conditional Formatting, and change the dropdown to Formula Is. Enter: -

    =SUM(E5:E15)>5

    and choose your format.

    Add a condition, and this time use the formula: -

    =SUM(E5:E15)<0.5

    and again choose your format.

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
  •