Hi Again Neal,

Step by step guide to format if cell equals a particular value (MCR):-

Select the range of cells where you want the conditional formatting.
Select menu item Format, Conditional Formatting.
Condition 1 leave default option €˜Cell Value Is.
Next box click drop down arrow and select €˜equal to.
Next box enter MCR.
Click Format button.
Select tab for type of formatting (Font, Border or Patterns)
Set the format required and click OK.
Click OK again.
Note: The above is NOT case sensitive.


Step by step guide to format if MCR is contained in cell (AMCRZ):-

Select the range of cells where you want the conditional formatting.
Select menu item Format, Conditional Formatting.
Condition 1: Click drop down arrow and select €˜Formula Is.
Next box enter =FIND(€œMCR€�,A1,1)0. (Note: A1 is the first cell of the
selected range)
Click Format button.
Select tab for type of formatting (Font, Border or Patterns)
Set the format required and click OK.
Click OK again.
Note: The above formula IS case sensitive.


The above formula can be replaced by the following for NOT case sensitive:-

=SEARCH(€œMCR€�,A1,1)0 (Note: A1 is the first cell of the selected range)

Hope this helps,

Regards,

OssieMac