# Colour scale with only red and green

Hey everyone, thanks again for the previous answer. I have two questions

1). How to colour scale with only red and green. So if numbers in B:B is greater than 0 it should be green and if it is less than 1 it should be red. I do not want it as a gradient just these two colours.

2) I want a formula that copies B:B if value in it is less than 1. I also want it to copy data in A:A too.
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Business Systems Analyst , ex-Senior Application EngineerCommented:
if you need to have exact color, try use Highlight Cells Rules instead.

Conditional Formatting
http://www.excel-easy.com/data-analysis/conditional-formatting.html
0
Finance AnalystCommented:
What about cell value = 0, not just less than or greater than zero? I think you will need two types of rule.

You can use the Highlight Cells as suggested by Ryan for one eg <0 but for the other you will need a formula:

=AND(B1<>"",B1=>0)

Where do you want the formula for copying A and B when value in B is less than 1? Is it absolute less than 1, or less than/equal to 1?

Assume, copy A into column C and copy B into column D

C =IF(\$B1<1,\$A1,"")
D =IF(\$B1<1,\$B1,"")
0

Experts Exchange Solution brought to you by