How do i change the colored cell values. Using conditional formatting I have changed the cell value into red using a condition cell value is = less than or equal to(zero) After that I want to change those red colored cell values filled with '-'.

Reputation: 11

How to change the colored cell values into special character using excel macro or by excel formulas?

How do i change the colored cell values.

Using conditional formatting I have changed the cell value into red using a condition

After that I want to change those red colored cell values filled with '-'.

Upvotes: 0

Reputation: 35597

Create a "Custom" format for the target cells:

In the Type window you have 3 areas divided by semi-colons:

£#,##0.00;-;-

The first section will be applied to positive numbers - the second to negative and the third to zero. Just type in the formats you want.

enter image description here

Works like this:

enter image description here

Upvotes: 2