I am currently using Excel 2000 to review and color code system logs (such as
backup logs). For example, I typically color code success entries as green,
and error (failure) entries as red.

I am aware of how to use conditional formatting at a basic level, and am
aware that I can use the €œCell Value Is€� €œequal to€� function, but this seems
to work only for text strings that equal the entire cell. This technique
does not seem to work for portions of text within a cell (keywords).

I would like to use conditional formatting as follows:

* If cell contains the word(s) €œsuccess€� or €œcomplete€�, highlight in green.
* If cell contains the word(s) €œerror€� or €œfailure€�, highlight in red.

I know that I can use the €œFIND€� or €œSEARCH€� function in an adjacent cell to
return TRUE if a word is present, and that I could then use conditional
formatting to make that cell highlight in a green or red color.

This technique seems to work if I implement conditional formatting on a
cell-by-cell basis. I have not as yet found a single formula that allows me
to use this technique across a range of cells because the €œFIND€� or €œSEARCH€�
functions need to be explicitly pointed to a given cell.

It is not efficient to implement this technique on a cell-by-cell basis €“ my
log files may contain several thousand lines of information.

Does anyone know of a method of effectively doing the following€¦

Select range = a1:a1000, implement conditional formatting such that if a
cell contains one (or more) keywords (success or complete), highlight in
green, and if the same cell contains one (or more) other keywords (error or
failure), highlight in red?

Any assistance is appreciated€¦
--
RichG