Coloring text based on criteria

[Sven]

Hi

I want to color my text based on a criteria. If the status (a field in table) is for example '1', then it should be in normal black color. If it's '2', it should be in green. '3' should be in red.

As I'm not familiar with the reporting stuff, I don't seem to get it to work.

thanks in advance

Sven

 

[Sven]

ok thx, worked out well with conditional formatting

sorry for late reply though, didn't had the time to work on it.

other little question: I have some fields in my report which contains error-values (beginning with '#'). I want to leave these fields empty, if there isn't a valid result. How would I do that?
I guess I have to do something with an if-statement, combined with some kind of error-check, but I haven't found a solution yet.

grtz

Sven

 

[Smart]

if you highlit the field in the design of the report and then click on the format option of the menu bar select conditional formatting

field value = 1
select the colour you want
add another condition and repeat above

 

[Sven]

if you highlit the field in the design of the report and then click on the format option of the menu bar select conditional formatting

field value = 1
select the colour you want
add another condition and repeat above

thats also the way I did it At first, I didn't find the menu for conditional formatting & thought I had to include this in the report's sql. NOT

Any ideas for the exception handling?