Now you know how to crosshair highlight in excel, essentially, how to highlight row and column of active cell. And also create a crosshair highlight with intersecting cell as a different colour. The next level is to disable the crosshair highlight when you do not need it, and enable the crosshair highlight when you need it. Essentially temporary highlight columns and rows intersecting cell when you need it and hide it when you do not.
And this is how you do it. These are the steps outlined in the video.
Create Pull Down Menu
1) Select cell B1
2) Data ~ Data Tools
3) Data Validation ~ Data Validation
4) Set Allow to List
5) Set location for On and Off
=$AN$3:$AN$4
Modify Conditional Formatting Formula
1) Ctrl + A
2) Home ~ Style ~ Conditional Formatting
3) Manage Rules…
4) Formula edits
Crosshair Center Cell
=IF($B$1=”On”,AND(COLUMN()=CELL(“COL”), ROW()=CELL(“ROW”)),FALSE)
For Column
=IF($B$1=”On”,COLUMN()=CELL(“COL”),FALSE)
For Rows
=IF($B$1=”On”,ROW()=CELL(“ROW”),FALSE)
5) OK
Here are the past videos of how to create a crosshair highlight in Excel.
🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Crosshair Highlight In Excel – How To Highlight Row And Column Of Active Cell -Excel Tips and Tricks
https://youtube.com/shorts/ZCI9VXk5D8Y?feature=share
Crosshair Highlight With Intersecting Cell As Different Color – In Excel
https://youtube.com/shorts/dlgV0UCP0WU?feature=share
How to crosshair highlight enabled and disable in Excel – Excel Tips and Tricks
https://youtube.com/shorts/roOnmcbgbTI?feature=share
How to Enable and Disable Crosshair Highlight for Rows or Columns in Excel – Excel Tips and Tricks
https://youtube.com/shorts/l763DsFNFFU?feature=share
Crosshair highlight in Google Sheet – Excel Tips and Tricks
https://youtube.com/shorts/_bjYH4xVK5k?feature=share
Crosshair Highlight With User Selected DropDown List in Excel – Excel Tips and Tricks
https://youtube.com/shorts/Y2c4gCd9fz0?si=Jc1fdfvgxUskC8kk
Crosshair Highlight With User Selected DropDown List in Excel – Excel Tips and Tricks – DETAIL EXPLANATION
Crosshair Highlight Entire Whole Workbook In Excel – Excel Tips and Tricks
https://youtube.com/shorts/yIlEHSA2RCM?feature=share
#microsoft #excel #exceltips #tips #exceltricks #tricksandtips