C
corey.helms
Here's a breakdown of what I'm trying to do...Employee scheduling
worksheet that is easy to read and follow. There are 5 functions
employees can have, each given a specific color via conditional
formatting. Each column represents a period of time during the work
day, each row a different employee. As it stands now, for the
duration that the employee will work, I simply enter a 1, 2, 3, 4, or
5 corresponding to their function, and it will color each cell with
that value.
The problem I run into, is in a separate sheet, I'm wanting to use
conditional formatting to apply the same codes to a summary sheet.
This summary sheet includes total hours worked each day of the week.
Is there a way to frame my logical test in conditional formatting to
scan a range of cells in a separate for any value entered and to
assign the summary sheet cell the corresponding function color? (i.e.
- if employee A worked function 1 at any given time on Day 3, Summary
Sheet cell corresponding to Employee A on Day 3 will be assigned
function 1 color)
worksheet that is easy to read and follow. There are 5 functions
employees can have, each given a specific color via conditional
formatting. Each column represents a period of time during the work
day, each row a different employee. As it stands now, for the
duration that the employee will work, I simply enter a 1, 2, 3, 4, or
5 corresponding to their function, and it will color each cell with
that value.
The problem I run into, is in a separate sheet, I'm wanting to use
conditional formatting to apply the same codes to a summary sheet.
This summary sheet includes total hours worked each day of the week.
Is there a way to frame my logical test in conditional formatting to
scan a range of cells in a separate for any value entered and to
assign the summary sheet cell the corresponding function color? (i.e.
- if employee A worked function 1 at any given time on Day 3, Summary
Sheet cell corresponding to Employee A on Day 3 will be assigned
function 1 color)