excel format cell if 1 entered 1

[coolicus]

In an Excel spreadsheet, is it possible to make the spreadsheet automatically format a cell if the value '1' is entered?

We would need the number to be red and bold in the cell, is that possible?

Thanks

 

[zahead31]

Select the cell(s) you would like to format this way... go to Format->Conditional Formatting

 

[coolicus]

That worked perfectly thanks, didn't know about that feature