ExcelBanter - conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - conditional formatting (https://www.excelbanter.com/excel-programming/409499-conditional-formatting.html)

greg

conditional formatting

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

Bernard Liengme[_2_]

conditional formatting

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

All times are GMT +1. The time now is 12:53 AM.