Hello :-),

I'm trying to create a membership/ban tracking system for a night club. I've got the basics setup but then they decided they wanted to track expired memberships as well.

A3-A2000 are setup for input of names B3-B3000 are setup for Y/N based on if the person entering the club is 21+ and then banned members are stored under P2-$P and Members are under S2-$S with the membership expire dates in T column and a formula to indicate if the membership is expired based on TODAY() - the date in the T Column. What I'm trying to figure out is there a way when a name is typed in the A column if the name is first a member and then expired can we setup a color for that?

Thanks

signin.xlsx