Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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? "Cheryl" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |