tinkerbell737
Board Regular
- Joined
- Nov 25, 2002
- Messages
- 96
I want to know if it's possible to use an If/Then formula to change a cell's color? Even changing the text color would be cool.
I have two worksheets in the same spreadsheet. The first one is a complete list of names and the second is a list of names in a particular group.
I want to say IF this person belongs to the group on worksheet2, then highlight the cell with their name on worksheet1.
Can this be done?
ALTERNATELY, I would be happy with a remark in another column that indicates that the person is part of the group.
I have two worksheets in the same spreadsheet. The first one is a complete list of names and the second is a list of names in a particular group.
I want to say IF this person belongs to the group on worksheet2, then highlight the cell with their name on worksheet1.
Can this be done?
ALTERNATELY, I would be happy with a remark in another column that indicates that the person is part of the group.