Highlight data with some color if condition fails

Hi ,

I would like my report to show data a different color if it is below a
certain number.

we have a field that needs to be at least 23 this is shown on the report. i
would like the color to be "RED" if it is below this number.

How can this be done?

Use conditional formatting (assuming Access 2000 or later.)

In report design view, right-click the text box and choose:
Conditional Formatting