Jehoshaphat Domfeh
asked on
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rob Henson
Solution covered both parts of question