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.