Ossie,
I thank you for your help. I had figured out the 1st one, that is
sensitive to how it's written, the latter, Even if i copy the formula as
written into a blank page, gives me an error. I'm not typing, just copy and
pasting, to see what happens. I can't find any problem with what you wrote,
it reads fine to me, can you help me trouble shoot it.
I did try to change the A1, to C6 because that is the first active cell of
use, but I still get the error saying the formual is wrong.
Neal
--
NealMed


"OssieMac" wrote:

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