View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dvonj[_2_] dvonj[_2_] is offline
external usenet poster
 
Posts: 2
Default Color text based on value

I'm using a great per-built Budget form but need to make some changes for it
to work the way we need it to. There is a column that displays the
difference between the actual amount spent and the budgeted amount. I would
like for this column to display red text if the value is minus(over budget)
and blue text if the value is positive(under budget).

Is there a macro or something I can use to make this work?
--


----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com