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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color text based on value
You could use conditional formating. Highlight the column and then click
Format -- Conditional Formatting. If you have problems from there, let me know. Hope this helps. Magnivy "dvonj" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color text based on value
Works like a charm. Found out we also need for it to stay the same if the
returned value is zero (on target) so with conditional formatting we get exactly what we want. Red for over budget, Blue for under budget and black if we are on target. Thanks for the tip. -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "Magnivy" wrote in message ... You could use conditional formating. Highlight the column and then click Format -- Conditional Formatting. If you have problems from there, let me know. Hope this helps. Magnivy "dvonj" wrote: 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 |
Reply |
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 |