Conditional Format Restrictions
Closed
Mike
-
Aug 3, 2015 at 06:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 6, 2015 at 11:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 6, 2015 at 11:13 AM
Related:
- Conditional Format Restrictions
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Samsung format code - Guide
- How to format hp laptop - Guide
- How to change whatsapp time format - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 3, 2015 at 11:59 AM
Aug 3, 2015 at 11:59 AM
Hi Mike,
So for example Joe Bloggs is in A1 and your initials are in B1.
If B1 is MM then A1 turns red and when B1 is anything else then A1 turns to normal.
Then select A1, apply conditional formatting and choose to use formula:
=B1="MM"
Best regards,
Trowa
So for example Joe Bloggs is in A1 and your initials are in B1.
If B1 is MM then A1 turns red and when B1 is anything else then A1 turns to normal.
Then select A1, apply conditional formatting and choose to use formula:
=B1="MM"
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 6, 2015 at 11:13 AM
Aug 6, 2015 at 11:13 AM
Hi Mike,
Yes, that makes more sense.
I would dedicate a sheet to create a list of customers and the staff members that are allowed to work with them. Then use Data Validation to only allow input of the correct staff members.
In case you are not familiar with the above, take a look at the sample book below:
http://ge.tt/7I1hBlL2/v/0?c
Will this work for you?
Best regards,
Trowa
Yes, that makes more sense.
I would dedicate a sheet to create a list of customers and the staff members that are allowed to work with them. Then use Data Validation to only allow input of the correct staff members.
In case you are not familiar with the above, take a look at the sample book below:
http://ge.tt/7I1hBlL2/v/0?c
Will this work for you?
Best regards,
Trowa
Aug 4, 2015 at 07:42 AM
So I have a spreadsheet of 50/60 different customers and for each day I'm inserting initials of the staff member that will be dealing with that customer.
However certain staff members are not allowed to work with certain customers so I need a formula that will pick up a restriction from an array. If there is a restriction against the initial I have input in the cell I want the cell to turn red until a new initial that doesn't have a restriction is keyed in the cell.
But for some customers there will be more then one staff member that can't deal with them
Does that make sense?
Regards