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

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)