Discover how to highlight active cell in Excel, or otherwise asked as how do I highlight only selected cells in Excel? This tip and trick will also answer how do you highlight the color of selected cells in Excel? It can also answers questions around how to change cell color when cell is clicked or selected in Excel? But can you highlight the active cell in Excel?
Here are the steps outlined in the video.
Conditional Formatting
1) Ctrl + A
2) Home ~ Style ~ Conditional Formatting
3) New Rule
4) Select “Use a formula to determine which cells to format”.
5) =AND(COLUMN()=CELL(“COL”), ROW()=CELL(“ROW”))
6) Format
7) Fill tab.
8) Select red color.
9) OK
10) OK
Animation
1) Right-click sheet. View Code.
2) Select Worksheet
3) Enter these in Worksheet_SelectionChange()
Target.Calculate
4) Ctrl+S to save
5) Close Code Editor
#microsoft #excel #exceltips #tips #exceltricks #tricksandtips