I would like to set colors to cells based on their values. If below or equal to 10, red. If between 10 and 70, yellow. If above or equal to 70, green. I tried using the Conditional Formatting feature, but all the blank cells in the range were colored red. The blank cells need to remain white. Any help will be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Cell color
- Thread starter rkawasak
- Start date
Jay Petrulis
MrExcel MVP
- Joined
- Mar 17, 2002
- Messages
- 2,040
Conditional formatting
Condition 1
Formula Is
=AND(NOT(ISBLANK($A$1)),$A$1<=10)
Condition 2
Formula Is
=AND($A$1>10,$A$1<=70)
Condition 3
Formula Is
=AND($A$1>70,ISNUMBER($A$1))
Format to suit.
Bye,
Jay
Condition 1
Formula Is
=AND(NOT(ISBLANK($A$1)),$A$1<=10)
Condition 2
Formula Is
=AND($A$1>10,$A$1<=70)
Condition 3
Formula Is
=AND($A$1>70,ISNUMBER($A$1))
Format to suit.
Bye,
Jay
Upvote
0
Hi Rk,
Based on what you posted, if I was the computer I would have coloured the blank cells red as well
You need to tell the conditional formatting at what point below 10 you want the cell to be white.
You said 10 and below or:
=> 10 RED so Null (blank) cells will be RED.
You might try a between statement in your conditional formatting. All cells BETWEEN .0000001 and 10 will be RED (this assumes that you will never have an amount less than .0000001).
Take care,
Tres
Based on what you posted, if I was the computer I would have coloured the blank cells red as well
You need to tell the conditional formatting at what point below 10 you want the cell to be white.You said 10 and below or:
=> 10 RED so Null (blank) cells will be RED.
You might try a between statement in your conditional formatting. All cells BETWEEN .0000001 and 10 will be RED (this assumes that you will never have an amount less than .0000001).
Take care,
Tres
Upvote
0
