Conditional Formatting for Specific Cells

[amoto]

Hello Everyone,

I have a spreadsheet that has several files each belonging to a different department. Column B will be a hidden and specifies the department the file belongs to. Columns G-N are the different departments, both their field and office designations.

I would like that when I list a file in Column A, Conditional Formatting uses the information from Column B to fill the two cells that pretain to the file. Basically indicating that those cells need to be updated. The next step after that would be that once I fill in the dates in the LIght Red they go back to no fill. I've attached an example for recerence.

Thanks in advance!