Hello. I have a report that has a status field that is either R, Y, or G. R = RED, Y = YELLOW, and G = GREEN. On the data entry form I am using check boxes to select the status for each. When we are reporting this to upper mgmnt they have a very specific format they want to see this in. What they want is for each cell in the R/Y/G column to contain the appropriate letter (R,Y,G) AND they also want the cell to be the corresponding color. So if the cell value is R then the report should show a red box with a black 'R'. Is there a way to format the report to change the background color for this one particular field based on the value (R,Y,G)? Thanks in advance.
