Creating a Formula to Format Column automatically?

  • Thread starter Thread starter bludovico
  • Start date Start date
B

bludovico

Does it matter what order the conditions are in? Some of them worked
some didn't
 
If you have 3 conditions, the order does not matter.

What matters is the content of the cell.

Not case-sensitive, but do you have any extra spaces if text?

If looking for numbers, are they real numbers or text that looks like numbers?

You used Joe Blow and Sally Smith as examples. What exactly are you entering
in the column D that some would work while others didn't?

Gord
 
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

Help needed 0
Automatic Conditional Formatting 1
Conditional Formatting 2
conditional formatting formula to highlight items on column B inrelation to column A 3
"cannot shift objects off sheet" error 8
macro for displaying conditional formatting 1
conditional formatting on formua with another cell 2
Conditional format Formula -Duplicate & n/a 1

Back
Top