![]() The formula returns TRUE if the cell is in. The formula should be OR (CELL ('col')CELL ('col',A1),CELL ('row')CELL ('row',A1)). Next, select Conditional Formatting and create a condition based on a formula. ![]() ![]() My solution is a little cumbersome and isn't a full solution to what you're looking for, but it combines both a tiny script and a little conditional formatting. Select cell A1 then select all the cells (click on the square at the intersection of the row and column headers). In fact, Conditional Formatting is a powerful function, it can help you to highlight the whole row, column or column and row of active cell, and changes with the cell moves, please do as follows: 1. I realize this question was asked a while ago, but I stumbled upon it when I was also looking for this same function. Highlight the row / column / column and row of selected cell with Conditional Formatting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |