Forum Discussion
Custom formating question
I'd use conditional formatting.
Select the column; the first cell in the selection should be the active cell. I'll assume it is D2 in the following.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=ABS(D2)<100000
or if you meant 100000%, use
=ABS(D2)<1000
Click Format...
Activate the Number tab.
Select Custom.In the Type box, enter the formula
"─";"─"
Click OK, then click OK again.
I'd use conditional formatting.
Select the column; the first cell in the selection should be the active cell. I'll assume it is D2 in the following.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=ABS(D2)<100000
or if you meant 100000%, use
=ABS(D2)<1000
Click Format...
Activate the Number tab.
Select Custom.
In the Type box, enter the formula
"─";"─"
Click OK, then click OK again.
- Thank you, this shows the "─" symbol for all the variances +-€100,000.
Would it be possible to only show the "─" symbol when the variance is negative?
This way my "▲" symbol shows even when the variance is a positive and less than 100,000.
