Hi
I have a project code which is generally a number such as 10.605...... but, i also have within the sane field, an alphanumeric project code such as 2796A, which it makes it difficult.... whcih is in column A.
I also have a column f which is definitely a number.
if i try to do conditional formatting ("if cell contains" like) it will not work as it has to be a numerical data.
Thus, essentially, i want to say if if cell A2 is populated with anything AND the corresponding F2 cell >0, then dont conditional format cell A2 in red ie not an error.
But, if F2 >0, and there is nothing in Cell A2, when there should be (alpahnumeric project code) then conditional format cell A2 ie an error.
If the above is not possible, then, can a macro be written to tell the user, all the errors in column A via a list on a userform or msgbox?
cheers
Jay
I have a project code which is generally a number such as 10.605...... but, i also have within the sane field, an alphanumeric project code such as 2796A, which it makes it difficult.... whcih is in column A.
I also have a column f which is definitely a number.
if i try to do conditional formatting ("if cell contains" like) it will not work as it has to be a numerical data.
Thus, essentially, i want to say if if cell A2 is populated with anything AND the corresponding F2 cell >0, then dont conditional format cell A2 in red ie not an error.
But, if F2 >0, and there is nothing in Cell A2, when there should be (alpahnumeric project code) then conditional format cell A2 ie an error.
If the above is not possible, then, can a macro be written to tell the user, all the errors in column A via a list on a userform or msgbox?
cheers
Jay
