Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear Experts:
I need to enter 9 digit numbers in column A. These item numbers have got the following make-up: ##-###-##-## I now would like to assign conditional formatting to the whole column A with the following condition: As soon as the entered number does not match the above syntax, the cell is to be filled red. Is that possible? Help is much appreciated. Thank you very much in advance. Regards, Andreas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting according to the date the data is entered | Excel Discussion (Misc queries) | |||
entering 16 digit numbers - last digit turns to zero | New Users to Excel | |||
conditional format on first & last digit on 3 digit cell data | New Users to Excel | |||
Formatting Numbers to 3 digit, | Excel Discussion (Misc queries) | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions |