In simple terms, a situational leader is one who can adopt different leadership styles depending on the situation.
Most of us do this anyway with our dealings with people: we try not to get angry with a nervous colleague on their first day, we chase up tasks with some people more than others because we know they’ll forget otherwise. Its knowing when to Direct, Coach, Support and Delegate.