Conditional Formatting Grief

[DodgeyAus]

G'day.

I've imported data from a spreadsheet, and one of the field values is "≤5". The other possible values are 6, 7, 8, 9 and N/A. The report is quite happy to format the cells for them, but refuses to do anything for ≤5. I've tried changing the data in the source spreadsheet to "<=5" and "'<=5", to no avail. I figured the latter would treat it as text, but it didn't make a difference. I've tried "Not equal to", and put the other values in, also without success. There's obviously something I'm missing, but I'm buggered if I can work out what. My assumption was that if I said, "If the value is ≤5, paint it red", and it was, it would paint it red! Bzzzz, wrong answer. Any help would be greatly appreciated.

Cheers, Rog

 

[Isskint]

Hi
I would probably try using "≤5" as the default colour.
So if you want the textbox?cell?Field? to go red with "≤5" in, set its background or foreground to red, then create conditional formats for 6, 7, 8, 9 and N/A and NULL

 

[arnelgp]

on your report, you can use Expression on Conditional Format:

Expression Is: [Field] = "<=5"

 

[DodgeyAus]

G'day Isskint & arnelgp,

Tried both of those. As it turns out, after playing with both suggestions, it was the sequence in which I had the formatting. Moving ""≤5" above "N/A" resolved the issue. Thanks for your time.

Cheers, Rog