"EEB3" wrote:
.. What I am trying to do have any cell that is in AA to become Black
if the cell in A does not contain "Ships" or "Personnel".
One way to get it going is to create a defined range for the 2 words,
then use it in a CF formula via SUMPRODUCT, like this:
Click Insert Name Define
Put under "Names in workbook:": MyList
Put in the "Refers to:" box: ={"Ships";"Personnel"}
Click OK
Then select AA3:AA6027 (AA3 active)
apply CF using Formula is:
=SUMPRODUCT(--ISNUMBER(SEARCH(MyList,A3)))=0
Format Fill color black OK out
Adapt/extend to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---