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?
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,"")
Ryan ChongCommented:
if you need to have exact color, try use Highlight Cells Rules instead.

Conditional Formatting
Rob HensonFinance AnalystCommented:
Solution covered both parts of question
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.