Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color in Cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color in Cell
You can use conditional formatting
Check out this great website Michael http://www.contextures.com/xlCondFormat01.html -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Michael Kintner" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color in Cell
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...htm#cellformat Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ron de Bruin" wrote ... You can use conditional formatting Check out this great website Michael http://www.contextures.com/xlCondFormat01.html "Michael Kintner" wrote ... 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}) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |