Previous Topic Next Topic

Change the Cell background color, based on another cells color

Closed
Megan - Feb 11, 2015 at 03:21 PM
 Megan - Feb 11, 2015 at 03:25 PM
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?



Related:

1 response

Answer 1 / 1
Megan
Feb 11, 2015 at 03:25 PM
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses