Hello - I am new to this board and not as advanced in excel as many of you, but I hope you can help me.

I have a spreadsheet that measures performance. I would like the cells in a column to be green if a certain value is exceeded, and red if it is not. Is this possible without having to mannually change the color in each cell? If so, can you give me specific instructions or refer me to where there are specific instructions on how to do this. Thanks.