I need to activate conditional formating on a range of cells but only if an individual cell has been clicked. Basically I need for the cell to behave the same as a command button. Any ideas on how to do this?