Hi

I think that "Conditional formatting" should do what you need.

Look at Debra Dalglish site:

http://www.contextures.com/xlCondFormat01.html

Regards,
Per

On 14 Dec., 09:01, tweety wrote:
Hi,
I have to create a trigger sheet which alerts / highlights whenever there is
an overstay by any staff.
For the workers the alert / highlighting take place on the basis of the
priority as in if we need the particular worker the priority is yes and if it
is yes and he overstayed we need to show the alert / highlights.