I want to be able to format a cell to turn a cetain color using 10 different
conditions.
For ex.

if cell B1=1 then turn the cell red
if cell B1=2 then turn the cell blue
if cell B1=3 then turn the cell orange
if cell B1=4 then turn the cell yellow

up to 6 more conditions