Without VBA you can highlight the whole row with a specific color. Through VBA code it is very easier. But many people do not like VBA or cannot use VBA code due to security purpose. Today I'm going to show you how can you highlight whole row based on your Active Cell.
Step by Step:
(1) Select entire workbook by pressing Ctrl+A.
(2) Click on Home | Conditional Formatting | New Rules | Use a formula to determine which cells to format.
(3) Use the formula =CELL("row")=ROW()
(4) Click on Format button and Select a Fill color
(5) Click Ok.
Now show the Cursor blinking by pressing F2 or Double Clicking a into a Cell. Then Click any Cell, that you want to highlight the entire row of that Cell.
Step by Step:
(1) Select entire workbook by pressing Ctrl+A.
(2) Click on Home | Conditional Formatting | New Rules | Use a formula to determine which cells to format.
(3) Use the formula =CELL("row")=ROW()
(4) Click on Format button and Select a Fill color
(5) Click Ok.
Now show the Cursor blinking by pressing F2 or Double Clicking a into a Cell. Then Click any Cell, that you want to highlight the entire row of that Cell.
Image 1: Setting of Conditional Formatting
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw