Can you conditionally format based on a color? I want each row's stoplight
color (green, yellow, red) to change based on the worst color in that row.
All the colors in the row are conditionally formated and will change as dates
are entered or changed.