Hi all,
I hope this is possible. If yes, hope someone could help me. I am trying to work on a conditional formatting, or formula if possible. But I prefer going to conditional formatting. For Example, the value of a cell should be 4-XXXXXXXXXXX (X = numeric, prefix "4-" remains the same or fixed for some reason) in short. 4-(eleven numerics). There are times when doing copy paste of that number on a specific Row, I miss 1 or 2 digits and only copied 4-(nine/ten digit numeric) which will result in data error/discrepancies which is inevitable and unnoticeable until you look closely or count the digit. Which is a pain in the ass to do every time I enter the data. I have to enter 50 to 80 cell data every day. So I want to check if there's a conditional formatting wherein if the cell has missing 1 or 2 digits entered (4-XXXXXXXXXX) the cell will turn to red or any background color. So I can easily notice if the data entered into the cell has missing digit. Another example, Correct data should be 4-12345678901 but if I accidentally pasted 4-1234567890 or 4-123456789, cell background should turn to red or any color.