C
chiuinggum
if cell is A1=100
how do i set a conditional formating for the following
1) if cell B1 value is greater than A1 by 20% fill blue
2) if cell B1 value is lower than A1 by 10% fill red
3) if cell B1 value is between condition (1) & (2) fill yellow
how do i set a conditional formating for the following
1) if cell B1 value is greater than A1 by 20% fill blue
2) if cell B1 value is lower than A1 by 10% fill red
3) if cell B1 value is between condition (1) & (2) fill yellow