• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1445
  • Last Modified:

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.
0
NedBishay
Asked:
NedBishay
  • 2
1 Solution
 
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
 
crgary_txCommented:
correction in the formula:

if{table.numericfield} mod 2 = 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.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now