Formating Odd and Even numbers

I have a report that displays a long list of numeric values and i want it so that if the number is ODD the colour is blue and if its even then RED.

Any help welcome.
NedBishayAsked:
Who is Participating?
 
crgary_txCommented:
correction in the formula:

if{table.numericfield} mod 2 = 1
then crblue
else
crred
0
 
crgary_txCommented:
>right click on the field you want to format->Format field
>click on the Font tab
>click on X+2 tab next to color
place the below formula:-

if mod({table.numericfield}) = 1
then crblue
else
crred
0
 
mlmccCommented:
Looks good.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.