Thanks:  0
Likes:  0

1. 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. 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. 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. 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. Dope!!! Thanks so much!!! That works great.

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

=SUM(E5:E15)>5

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

=SUM(E5:E15)<0.5

## User Tag List

#### Posting Permissions

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