Am trying to produce a checklist or scorecard that uses the tradition
traffic light colors to indicate levels or risk. Is there a way,
without merging cells, so that if say cell A5 meets the criteria for a
Red and white conditional format, the Cells B5, C5, D5 and E5 are also
Red and white conditionally formatted?

Thanks,
Thanos