Apr 14 2022 07:30 AM
When evaluating the following formula, I would like the result to print is black if positive and red if negative: ="CY - "&TEXT(SUM(W3:W30),"$#,##0_);[Red]($#,##0)")"
Any help will be very much appreciated.
Apr 14 2022 07:53 AM
You cannot specify the color in the formula, it will be ignored. So use
="CY - "&TEXT(SUM(W3:W30),"$#,##0_);($#,##0)")
Also, you cannot color part of the result of a formula. If you wish, you can color the entire result using conditional formatting:
Select the cell with the formula.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=SUM(W3:W30)<0
Click Format...
Activate the Font tab.
Select red as font color.
Click OK, then click OK again.