Formula to change available seats

[airbus2]

I am creating a event/class scheduler DB. I am wanting to create a formula that takes max available seats for each class (entered by user) minus number of attendees (auto increased every time a person is enrolled to the class) that will auto reduce number of seats available. I also have seen where the "seats available" field color changes based on status of the counts. It's red when the minimum number of attendees required is not met. Once the minimum number is met the color in the field changed to green. Once it is with 2 of the max number of seats it turned yellow.

Example:

Max # of Attendees (field) 12
Enrolled 5
Seats Available (filed) 7
Minimum # of Attendees 2

Any help on this is greatly appreciated.

 

[randy700]

The number of seats available will be a calculated value. You should base your form on a query that returns that data.
For the color changes, take a look at conditional formatting.


Randy