Color in Cell

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

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
 
Hi Mike,
If I understand you correctly, you can use normal cell formatting
for that. Of course Conditional Formatting would override
color if you used both.

Format, cells, custom
[Green][=1]"Yes";[Red]"No";[Red]"No";@

[Green][=1]General;[Red]General;[Red]General;@
shows number as green for 1, red for other numbers, black for text

In the US the list separator in Regional Settings is a semi-colon
and the thousands separator is a comma.

Regular Cell Formatting some examples
http://www.mvps.org/dmcritchie/excel/formula.htm#cellformat

Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm


--
 
Back
Top