Can I set a cell to equal a font color, such as:
if any cell within B4 to B21 equals "1" I would like the "1" to
automatically come up red, if its a "2" then it will be yellow.
Thanks