Based upon an if statement how can I tell the cell value to display in
different font color.

Example: =if(A1=1,{display cell A1 in green},{display A1 in red})

Thanks in advance for any help,
Mike