| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font Color
Hey, If my formula comes back a negative I want the font to turn red. Thanks, Jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=524102 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Font Color
Sounds like a job for Format|conditional formatting.
jwfakouri wrote: Hey, If my formula comes back a negative I want the font to turn red. Thanks, Jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=524102 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Font Color
Format, Cells, number OR currency.
HTH Gilles "jwfakouri" wrote in message ... Hey, If my formula comes back a negative I want the font to turn red. Thanks, Jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=524102 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Font Color
Click your formula cell, Use 'Format' 'Conditional Formatting' select
'Cell Value Is' select 'Less Than' Enter '0' Select the format you want, OK, Regards, Alan. "jwfakouri" wrote in message ... Hey, If my formula comes back a negative I want the font to turn red. Thanks, Jason -- jwfakouri ------------------------------------------------------------------------ jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435 View this thread: http://www.excelforum.com/showthread...hreadid=524102 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I correct uncommanded font color changes. | Excel Worksheet Functions | |||
| Event Macro adjustment needed - need to change font color also | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Sumif and base it on font color of cell | Excel Worksheet Functions | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
