Petunjuk cara buat Focus Cell pada MS EXCEL

Focus Cell MS Excel 

Using Conditional Formatting:

Select the range: Select the entire area of your worksheet where you want the highlighting to work.

Go to Conditional Formatting: On the Home tab, click "Conditional Formatting" and then "New Rule...".

Create a new rule: Choose "Use a formula to determine which cells to format" and enter the following formula (assuming your active cell is A1): 

=OR(ROW()=CELL("row");COLUMN()=CELL("col"))

Format the cells:

Click "Format..." and choose a fill color (e.g., light gray) to highlight the active row and column. 

Apply the rule:

Click "OK" to apply the rule. The cells in the active row and column will now be highlighted. 

klik all range dahulu ; lalu

Setelah itu masuk pada manage rule di conditional formatting:

masukkan new rule, ganti rumus depan dengan and : =AND(ROW()=CELL("row");COLUMN()=CELL("col"))

pilih background color : no color (jika mau pilih warna lain sebagai pembeda juga boleh...)
pilih apply

setelah itu aktifkan macro dengan klik kanan pada sheet dan pilih view code:

copy kan file berikut:

Private Sub worksheet_SelectionChange(ByVal target As Range)

Target.Calculate

End Sub

pilih simpan atau tekan ctrl+S

Bisa tekan tombol F9 untuk execute setiap kali klik tanpa macro