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. br br And this is how you do it. These are the steps outlined in the video. br br Create Pull Down Menu br 1) Select cell B1 br 2) Data ~ Data Tools br 3) Data Validation ~ Data Validation br 4) Set Allow to List br 5) Set location for On and Off br =$AN$3:$AN$4 br br Modify Conditional Formatting Formula br 1) Ctrl + A br 2) Home ~ Style ~ Conditional Formatting br 3) Manage Rules... br 4) Formula edits br Crosshair Center Cell br =IF($B$1="On",AND(COLUMN()=CELL("COL"), ROW()=CELL("ROW")),FALSE) br For Column br =IF($B$1="On",COLUMN()=CELL("COL"),FALSE) br For Rows br =IF($B$1="On",ROW()=CELL("ROW"),FALSE) br 5) OK br br br Here are the past videos of how to create a crosshair highlight in Excel.