Hi All,
I am trying to create a conditional formatting rule for a working spreadsheet we use at work. We have column A listed as a specific account new to our business. The person working on that item has their name in column B. In Column C it is left blank until that Item is completed then we insert an "X" marking it complete. My question is this, is there a way to create a rule for column C (where the X goes) if the name in column B is "BOB" and column C is Blank then it is formatted to a specific color for BOB. If the name in column B is Sally and column C is blank then her color formats the blank cell. This is so each employee can look and see his or her color on the sheet and know they have an item outstanding. Once this item is complete you enter an "X" and the cell goes back to being White fill.
Can someone assist me in this? I think I am so close to it but can not put a finger on it. I have done the conditional formatting in the Item complete or not cell by making a rule that says if blank then format Blue and once I enter an X it goes to white fill. I know there is a what to make them format the color based on the person's name in the cell beside it.
10Pts to Gryffindor if you can assist!
I am trying to create a conditional formatting rule for a working spreadsheet we use at work. We have column A listed as a specific account new to our business. The person working on that item has their name in column B. In Column C it is left blank until that Item is completed then we insert an "X" marking it complete. My question is this, is there a way to create a rule for column C (where the X goes) if the name in column B is "BOB" and column C is Blank then it is formatted to a specific color for BOB. If the name in column B is Sally and column C is blank then her color formats the blank cell. This is so each employee can look and see his or her color on the sheet and know they have an item outstanding. Once this item is complete you enter an "X" and the cell goes back to being White fill.
Can someone assist me in this? I think I am so close to it but can not put a finger on it. I have done the conditional formatting in the Item complete or not cell by making a rule that says if blank then format Blue and once I enter an X it goes to white fill. I know there is a what to make them format the color based on the person's name in the cell beside it.
10Pts to Gryffindor if you can assist!
