Change the Cell background color, based on another cells color

Megan - Feb 11, 2015 at 03:21 PM
 Megan - Feb 11, 2015 at 03:25 PM
i have a spreadsheet with Sheet 1 and Sheet 2.
There is a list of employee names in column A and dates across row A.
If an Employee is offshore on one project in Sheet 1 I color the cells manually Green.
I would like the cells for the employee's name in sheet 1 to be "Grayed out" because they are obviously not available for working on a sepereate project... Any help?


1 response

Sorry, let me Clarify,
If an employee on SHEET 1 is working I color those green
I would like the same employees name in Sheet 2 to go GREY as they are not available to work

It looks like this on Sheet 1
11 feb 12 feb 13 feb 14 feb 15 feb
Megan Green Green Green

I would like sheet 2 to automatically turn the same cells Grey