Michelle0918
Board Regular
- Joined
- Nov 14, 2013
- Messages
- 66
Hello,
I have column M that has a Left String formula in it to pull some 4 digit numbers : =LEFT(I43,4)
I would like to conditional format all of column M so that if it pulls anything that starts with a number value that it is basically a white or no-fill color background, but if it pulls anything that starts with a letter and not a number, it formats as a Red background so that I can check & balance my work.
Thanks!
I have column M that has a Left String formula in it to pull some 4 digit numbers : =LEFT(I43,4)
I would like to conditional format all of column M so that if it pulls anything that starts with a number value that it is basically a white or no-fill color background, but if it pulls anything that starts with a letter and not a number, it formats as a Red background so that I can check & balance my work.
Thanks!