View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default font color depending upon value possible?

If you can't find a suitable format using Format/Cells/Number/Custom's
installed formats, try formatting the calculated cell with

Format/Cells/Number/Custom [Black]General;[Red]General or

[Black]General;[Red]-General

etc.


In article ,
"DrB" wrote:

Would like to have calculated cell value from other cells show in black
color if positive and in red if negative. Is this possible?