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.
Jehoshaphat DomfehAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

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

Conditional Formatting
Rob HensonFinance 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:


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,"")

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
Solution covered both parts of question
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.