Excel 2007 :: How To Stop Conditional Formatting From Copying To Adjacent Cell

Excel 2007.

I have conditional formatting set up so that the cell becomes highlighted if it contains a specific text.

Example of wanted conditional formatting:

Conditional formatting rules manager
Rule

Format

Applies to

Stop if true

[Code] ......

For some reason this formatting is inherited by another adjacent cell as we continue to input information.

For example:

Column M is formatted so if 'AP' is placed in any cell in that column the cell fills pink. As more information is inputted into the sheet, the conditional formatting copies to Column N. It does not happen with every entry and I have not been able to isolate the specific steps to recreate the copying. Multiple people use the same sheet and fill it out and needed.

After working with the sheet changes are made to the "applies to" column without people meaning to.

For example:

Conditional formatting rules manager
Rule

Format

Applies to

[Code] .......

I would like to make this formatting so that is only applies to the Column M and not "travel" to other cells of the sheet.