Is it possible to click a cell and cause the corresponding row and column to turn to a particular color

For eg. there is data tabulated from columns A to E and rows 1 to 10.
If I click on cell C5 can it make the entire C column and 5th row highlight to a pre decided color?

1 Answer(s)


Normal highlighting based on values entered can be done using conditional formatting.

But since you want your color to change based on clicking a cell - this can be done using macros. You can record a macro that contains the exact steps that you described in your question. the