Change the Cell background color, based on another cells color Closed

Question

Hello, 
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?



Configuration: Windows 7 / Internet Explorer 9.0

Megan · Answer

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

Change the Cell background color, based on another cells color

1 response

Similar discussions

Subscribe To Our Newsletter!