I would like to be able to conditionally format data that is contained within
a cell even if there is other data in the cell.

For example:

A2 - East-NE-NO-ETC
A3 - East-NE-TP-Critical
A4 - East-SE-NO-Investment
A5 - East-SE-CM-Investment

Id like to be able to conditionally format all of the cells in Column A
that contain €œNE€� to be one color, and all that contain €œSE€� to be another
color.

Is that possible? How? Thanks in advance for any input!