hi
how can i write a formulae that changes the color of the text based on the value. ie, results from a database return values of sales made this week.
example: teddy bears: Mon Tue Wed Thurs
____________________5___3____1____0
__________barbie dolls:4____2____2____1
how can i change the color of the numbers to RED if they are 2 or lower on the report? so if in case of teddy bears,wed & thurs results would be in Red, mon and tue in default black.
anyone know how to go about doing this?
cheers.