Software

Ask something
Discussion Locked

Conditional formating in Access

0 helpful
4 replies

by nuinfluences

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have some calculations to find the percentage of the sum of some figures, This can be a negative percentage I need to have these figures in Red I have tried Cond Formatting to say if less than 0 then text is red but this does nothing what am I doing wrong

4 replies

by nuinfluences

#,##0;-#,##0[Red] Is the format I have used in the text box to turn the normal numbers Red but how do I do it with the percentages ??

Thanks In Advance

by bob sellman

Use the same format, but include a percentage sign. For example, if you want one decimal place and no commas:

#.00%;#.00%[Red]

If you want commas and no decimal places:

#,###%;#,###%[Red]

Note that this takes the value and converts it to a percentage, so .55 becomes 55%.

This discussion is closed to new replies.