how do i display a negative percentage in red?

R

rendude

Doe anyone know how i can display a negative percentage in red font? and of
course if it is a positve percentage then just display it in black... or is
there a function with the if function where you can choose the colour of the
result?

This is for a profit/loss formula, at the moment i have managed to get a
negative result by using this formula =IF('Additional
Data'!A3<0,-(B17-B8)/B17,'Additional Data'!A3) but i would like it to display
in a different colour automatically to make it stand out
 
D

DL

Basically its an option in the properties/Format of the field
Using Access something like this,
£0.00[Black];£0.00[Red] though this formats a currency field, negative being
red.
In Excel its a straight option in the field format
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I show negative percentage in a fomula? 1
How do I calculate variance percetage if figures are negative 5
Displaying negative values 5
Formating cells to display negative percentages in red fon... 3
Showing negative values for formula results in red 5
How do I make a negative balance automatically appear in red? 2
How do I write a custom format to make a negative percentage red 2
Color a calculated percentage cell text red if results negative 3

Top