Conditional formatting with the color tab code

Hello all,
I was trying to resolve the issue in the Sheet1. My Sheet1 supposed to work like Sheet2.
I added a conditional format in K8 so the sheet1 has a little different vba code than the sheet2.

When you press tab the color tabbing supposed to follow where your cursor is.

See my attachment sample worksheet.

Thank you.

On the "Private Sub Worksheet_SelctionChange(ByVal Target As Range)" for Sheet1 try changing

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Alf

Hi
I did change it but the conditional formatting in K8 stop working.

This then, not pretty but it seems to work and keeps format in K8 as long as the cell contains "BANANA"

Please Login or Register  to view this content.

Alf

Hi,
The code is ok but the problem is that when you tab it stays in cell K8.
Everytime press tab key, it keep going back to that cell K8