Hello everyone,
I have a file with projects' staffings. Some of the workers assigned to these projects are temporary employees, some of them are permanent ones and some of them are leads. I would like to create a conditional formatting rule that highlights the permanent, associate leads and leads staff based on highlighting the duplicates so I have created three rows; one for perms, one for ALs and one for leads. The rule would stop once the drop down in the file is set to Disabled. It worked perfectly fine when I created a rule for perms, but while adding the rules for ALs and leads it started to cause problems.
Here is an example of how I would like it to look like:
The file highlights the regular duplicates as well, which is the most important rule in the file. It does not use any enable/disable drop down. To stop the perms+ highlighting I have used such formula:
When adding the conditional formatting for AL's/Leads only one of the drop downs works and enables the highlighting, but it highlights all of them at once, instead of enabling only one of them.
Can someone describe how should I do this, step by step? Macro can do as well
Cheers,
TLSeb
I have a file with projects' staffings. Some of the workers assigned to these projects are temporary employees, some of them are permanent ones and some of them are leads. I would like to create a conditional formatting rule that highlights the permanent, associate leads and leads staff based on highlighting the duplicates so I have created three rows; one for perms, one for ALs and one for leads. The rule would stop once the drop down in the file is set to Disabled. It worked perfectly fine when I created a rule for perms, but while adding the rules for ALs and leads it started to cause problems.
Here is an example of how I would like it to look like:
The file highlights the regular duplicates as well, which is the most important rule in the file. It does not use any enable/disable drop down. To stop the perms+ highlighting I have used such formula:
Code:
=$F$3="Disabled"
Code:
=$F$4="Disabled"When adding the conditional formatting for AL's/Leads only one of the drop downs works and enables the highlighting, but it highlights all of them at once, instead of enabling only one of them.
Can someone describe how should I do this, step by step? Macro can do as well
Cheers,
TLSeb
