Cell Click Event

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?:confused:

That's how I do everything, say you wanted to use cell B3...

VB Code:

If ActiveCell.Address = "$B$3" Then
    Do WhatEver
End If

Do you execute this code on a sheet.activate or auto_open or sheet.select?

VB Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

My bad, there ya go. :D