S
Stepha
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.
somewhere in the cell. I can not figure it out.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Otto Moehrbach
Look up Conditional Formatting in Help. HTH Otto
J
John
HI Stepha
Select the range you would like to format then go to >Format>Conditional
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
Select the range you would like to format then go to >Format>Conditional
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
D
David Biddulph
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") ?
the two double unary minuses, John, but why
=OR(--(A2="mr"),OR(--(A2="sr")))
and not just
=OR(A2="mr",A2="sr") ?
J
John
HI David
Just not taking the time to think maybe going to fast.
Thanks
Just not taking the time to think maybe going to fast.
Thanks