Okay... I'm building an attendance sheet, each tab has the name of each employee - if an employee has an absence the cells its referencing are shown as 'a' in each month which makes my cell conditionally format to red to issue a informal corrective. On the other tab shows a total of all employees and where they stand, i.e. informal, format, final. How do I get the 'other' tab to flash red if the individual employee tab is flashing red to issue an informal?

I hope I was detailed enough...