cross table colors - cell color based on another column's value?
I have a table with column [serial_number] corresponding to list of equipment serial numbers. A 2nd column [condition] has value 1,2,3 for each serial numbers, which I successfully color as Green, Orange, Red. The problem is I do not want to show 1,2,3 in each cell, and I do _not_ want or need this column used in the table (just the color reference).
My question: Rather than show 1,2,3 in each cell, I want to show the serial_number in each cell , but colorize with color from [condtion]. in other words, is there a way to color a cell based on values from a different column?