Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing font color based on positive or negative number
Hello everyone,
I'm attempting to make a budget in Excel and would like to format a cell to turn bold and red when the sum equals a negative number and for the cell to turn bold and black when the sum equals a positive number. I believe there is a way to do it but I'm not sure how to go about doing so. Any help you can provide would be great. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing font color based on positive or negative number
Hi Joe
Use conditional formatting. Find it in the format menu. Happy New Year! Per On 30 Dec., 05:24, Joe wrote: Hello everyone, I'm attempting to make a budget in Excel and would like to format a cell to turn bold and red when the sum equals a negative number and for the cell to turn bold and black when the sum equals a positive number. *I believe there is a way to do it but I'm not sure how to go about doing so. *Any help you can provide would be great. *Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing font color based on positive or negative number
You can use NumberFormat. The -ve format is between the 1st & {optional) 2nd
semi-colons. Look at the examples in Custom, or simply "General;[Red]-General" without the quotes. Programatically, dim rng as Range dim sNumFmt as string sNumFmt = "#,##0.00;[Red]-#,##0.00;[Blue]""zero""" set rng = Selection rng.NumberFormat = sNumFmt Regards, Peter T "Joe" wrote in message ... Hello everyone, I'm attempting to make a budget in Excel and would like to format a cell to turn bold and red when the sum equals a negative number and for the cell to turn bold and black when the sum equals a positive number. I believe there is a way to do it but I'm not sure how to go about doing so. Any help you can provide would be great. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Changing a cell color to reflect positive or negative total | New Users to Excel | |||
How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
Changing Positive to Negative | Excel Worksheet Functions | |||
Changing font color based on the values | Excel Programming |