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
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?