Numbers
Is there a way to have a cell highlight red or green based on a value range automatically.
example
if a32 =>50 it would highlight green
if a32 =<50 it would highlight red
Yes, if you are trying to highlight cell A32 based on the contents of cell A32. Click on the Conditional Highlighting button in the Cell tab of the format sidebar. If you can't figure out how to do it, come on back.
Highlighting a cell based on the value of another cell is not as easy.