Correct, cell A1 has no way to know you have selected cell B1 other that with
a VBA event rountine.
--
www.stfx.ca/people/bliengme


"greg" wrote:

OK, strange question.
I would like to change the color of one cell, when I just select another
cell.
I know this can be done with Workbook_SheetSelectionChange.
But I am wondering any other ways. Just to know.
I don't think it can be done in conditional formatting. But can someone
confirm?
thanks