Hi,

I have created a reservation list for the max. capacity of tables in a restaurant.

In the one column will be entered the number of guests, the next column calculates the amount of tables needed.

In one cell will appear the number of tables used in total with the note if tables will still be available or if the restaurant is full.

I am looking now for a formular in the conditional formating that highlights automatically the cells in the column for the needed tables if there is going to be an overbooking with the next reservation made.

To make it more understandable:

The formular of the cells for the tables needed is

=IF(D6=0,"",IF(D6<5,1,IF(D6<7,2,IF(D6<9,3,IF(D6<11,4,IF(D6<13,5,IF(D6<15,6,IF(D6<17,7))))))))
and
=IF(K6=0,"",IF(K6<5,1,IF(K6<7,2,IF(K6<9,3,IF(K6<11,4,IF(K6<13,5,IF(K6<15,6,IF(K6<17,7))))))))

For both columns the cell counting the total of tables needed
=IF(K31>24,"FULL","AVAILABLE")

Based on the total of tables needed I want the cells in the columns for the reservation of the tables to change the color as soon as the K31 shows FULL.

Thanks for your help