CODEWITHSUNDEEP
excel
Vin
Vin

Reputation: 13

How to format the whole sheet depending on a cell value

The title may be a little misleading, anyway, this is what I'm trying to do.

I have this sheet that is supposed to show employee leave dates and mark them in the sheet with a color depending on the department the employees work at. So what I'm trying to do is what the image says below Image link here, since I don't have enough points to embed images

So, on the left we have Engineer, Sales, IT, and Engineer, and want I want to do is color the cells on the right that have 'v' on them a color depending on the department.

On the image I did it manually, just for demonstration purpose, Engineer's should automatically become green, Sales, a different color, IT a different color, and so on. And this must be done on the whole sheet as more employees will be added to the sheet. And whenever I enter the value 'v' to an empty cell it gets colored based on the employee's department.

Upvotes: 0

Views: 32

Answers (1)

David Culbreth
David Culbreth

Reputation: 2796

You'll have to go look into the conditional formatting options for the table.

To achieve what you want, you'll want to make one rule for each department with your own conditional rule that goes something like:

=AND($A2 = "Engineer", F2 = "V")

F2 being the cell, A being your first column, and 2 being your first row.

Upvotes: 1

Related Questions