sunday_storyteller
Board Regular
- Joined
- Jun 22, 2007
- Messages
- 51
I have two worksheets with location names on them. Each location name is unique. The lists are generated for two different weeks. I would like to set conditional formatting so that if a Location on the 2nd sheet shows upon the 1st sheet, it is highlighted. (So I can flag which locations showed up twice in a row.)
Is this possible? To do a conditional formatting based on a list? That is, "if this location on Sheet2 is equal to a location on Sheet1, then highlight the location on Sheet2"
Thanks!
Calinda
Is this possible? To do a conditional formatting based on a list? That is, "if this location on Sheet2 is equal to a location on Sheet1, then highlight the location on Sheet2"
Thanks!
Calinda