Excel 2003

  • Thread starter Thread starter Stepha
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to return column letters 4
Auto Fill With Letters 3
How do I turn off auto color fill? 1
Autofill column values in formulas 4
How to filter rows data based on background color of individual cells 1
Repeat Cell Data in Ranges 6
Conditional formating 4
HELP!!! I need macro to autofill 4

Back
Top