cell B1=10
if cell A1 value is greater than B1 (say A1=11 ) , I want Cell B1 to be filled with RED
if cell A1 value is less than B1 and B1 is larger by 10% or less (say A1=9.1,9.8,9.5) , I want Cell B1 to be filled with GREEN
if cell A1 value is less than B1 and B1 is larger by 10.1% to 20% more (say A1=8.9,8.5) , I want Cell B1 to be filled with Blue
if cell A1 value is less than B1 and B1 is larger by 20.1% or more (say A1=7.8,7) , I want Cell B1 to be filled with Cyan
What should be formula??
if cell A1 value is greater than B1 (say A1=11 ) , I want Cell B1 to be filled with RED
if cell A1 value is less than B1 and B1 is larger by 10% or less (say A1=9.1,9.8,9.5) , I want Cell B1 to be filled with GREEN
if cell A1 value is less than B1 and B1 is larger by 10.1% to 20% more (say A1=8.9,8.5) , I want Cell B1 to be filled with Blue
if cell A1 value is less than B1 and B1 is larger by 20.1% or more (say A1=7.8,7) , I want Cell B1 to be filled with Cyan
What should be formula??