Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am entering a Post Code into a column and want to be able to set the
conditional formatting so that if it is not entered in the format "letter
letter number number / number letter letter" it turns red. (e.g. using zeros
instead of O's)

Does anyone know if this is possible?

Many thanks,

Cheryl
 
I don't if it's possible but if these are UK post codes (and it looks like
(one) UK format) then the formats are more variable in the first section then
your selection indicates.

W1 9BB, W12 8CC, PO8 7XY are all valid

Do you require a full post code FORMAT validation?
 
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

Using wildcards with logical (IF, AND) conditional formatting 2
Conditional Formatting - letters present 5
Conditional formatting 3
Conditional formating a cell containing a date 1
Excel Use COUNTIF across a range of cells with formulas 0
Conditional Formatting 1
Conditional Formatting 7
Conditional Formatting from a group 6

Back
Top