Cell Click Event

[[email protected]]

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?

[Spajeoly]

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

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

[[email protected]]

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

[Spajeoly]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

My bad, there ya go.