Excel 2003
 

I want to have a field autofill with color if the letters MR or SR are
somewhere in the cell. I can not figure it out.

Excel 2003
 

Look up Conditional Formatting in Help. HTH Otto
"Stepha" wrote in message
...
I want to have a field autofill with color if the letters MR or SR are
somewhere in the cell. I can not figure it out.

Excel 2003
 

HI Stepha
Select the range you would like to format then go to FormatConditional
Formatting
change " Cell Value is " to " Formula is " next box copy this formula
=OR(--(A2="mr"),OR(--(A2="sr"))). This formula assume that the first cell in
your range is A2 change it to your needs then press Format and Pattern and
choose your colour.
HTH
John
"Stepha" wrote in message
...
I want to have a field autofill with color if the letters MR or SR are
somewhere in the cell. I can not figure it out.

Excel 2003
 

I'm note quite sure what you are trying to do with your two OR functions and
the two double unary minuses, John, but why
=OR(--(A2="mr"),OR(--(A2="sr")))
and not just
=OR(A2="mr",A2="sr") ?
--
David Biddulph

John wrote:
HI Stepha
Select the range you would like to format then go to
FormatConditional Formatting
change " Cell Value is " to " Formula is " next box copy this formula
=OR(--(A2="mr"),OR(--(A2="sr"))). This formula assume that the first
cell in your range is A2 change it to your needs then press Format
and Pattern and choose your colour.
HTH
John
"Stepha" wrote in message
...
I want to have a field autofill with color if the letters MR or SR
are somewhere in the cell. I can not figure it out.

Excel 2003
 

HI David
Just not taking the time to think maybe going to fast.
Thanks
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I'm note quite sure what you are trying to do with your two OR functions
and the two double unary minuses, John, but why
=OR(--(A2="mr"),OR(--(A2="sr")))
and not just
=OR(A2="mr",A2="sr") ?
--
David Biddulph

John wrote:
HI Stepha
Select the range you would like to format then go to
FormatConditional Formatting
change " Cell Value is " to " Formula is " next box copy this formula
=OR(--(A2="mr"),OR(--(A2="sr"))). This formula assume that the first
cell in your range is A2 change it to your needs then press Format
and Pattern and choose your colour.
HTH
John
"Stepha" wrote in message
...
I want to have a field autofill with color if the letters MR or SR
are somewhere in the cell. I can not figure it out.