Conditional formating depending on value

kuzcomerlin, Good afternoon.

Select the colunm you want color.
Go to Conditional Format Menu --> New Rule --> Using Formula

Formula =$k$31="FULL"
Select the color you want at the format field.
OK.

Is this what you're looking for?
I hope it helps.

Welcome to the forum.

Select the cell with the formula =IF(K31>24,"FULL","AVAILABLE")

In Conditional Formatting, New Rule, Use formula.... enter this formula:
I have used M1 for the cell with the formula for this example:

Formula:

Please Login or Register  to view this content.

Choose the formatting that you want for full. Click OK, Apply and click OK.

With M1 still selected enter the following in Conditional Formtting, New Rule, Use formula...

Formula:

Please Login or Register  to view this content.

Choose the formatting for AVAILABLE. CLICK, OK, APPLY, OK.

In this very simple example (only 2 cells used) change the value in K31 and see the colour change in M1

You were given 2 different suggestions. Which 1 does not work, what what does "does not work" mean? What is it/is it not doing? (thats like saying "my car is making a funny noise")

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

I have created two columns of table requirements using your formulae with the total in K31. I also inserted in between the columns of guests and tables a cell that will either indicate Available or Full depending upon the total in K31. If Full, Full will be displayed in red with bold white font and the columns with the table requirements will also turn red until K31 drops to 24 or less.