for now i have done "[Green]0.00 ;[Red]-0.00;[Blue]0;[Cyan]"Nothing Entered" in the format options in query. But anyone can correct my condition instead of [positive, negative, zero, none entered] i want to test for <>. If i write the format like this
"[Green] >3 ;[Red]<3 ;[Blue]0;[Cyan]"Nothing Entered"
It just display >3 or <3 next to the current value in my table.
I would also like ask if it is possible to color the cell background instead of only the text using the format options. Thank you.