All data at Column D from “Data” sheet are copied to Week1 to Week5 sheets according to date and time (Column A- Data sheet). I would like to request Experts help create a macro which is able to highlight a cell in Week1 to Week5 in “Yellow” if that data has “TypeA” at Column B (Data Sheet). And, highlight with “Gray” if the Data matched with “TypeB” (Column B – Data Sheet). E.g. Cell B6 (week1) is highlighted with “yellow” since this data has identified with “TypeA” at Data Sheet (B9). Similar goes with Cell C10 (week1) is highlighted in “Gray” since the data is identified with “TypeB” (C38-Data sheet). Attached the workbook for Experts perusal.