Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum cells based upon color of text | Excel Worksheet Functions | |||
How to set color for text based on conditions? | Excel Discussion (Misc queries) | |||
sort based on text color | Excel Discussion (Misc queries) | |||
Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
Formatting based on text color | Excel Worksheet Functions |