Zend certified PHP/Magento developer

In MS Excel sheet, how to automatically fill up a group of cells when one of them is set up?

In MS Excel, for a range of cells in a column, if anyone of the cell is chosen to be “YES”, the rest will be “NO” automatically. How to set this up?