I need something that would look in specific columns and throw (Seperate message box) warnings, and highlight offending cells (seperate) colors if cells values meet any of the following criteria:
If values of any cells in columns C, D and E have ANYTHING other than a number or a decimal point in it then:
msgbox "bla bla bla"
highlight offending cells orange
If values of any cells in columns C, D and E are less than one (but greater than zero), then:
msgbox "more bla bla"
highlight offending cells yellow
If values of any cells in columns C, D and E are zero, or blank entirely, then:
msgbox "bla bla bla bla"
highlight offending cells red
If values of any cells in columns C, D and E meet MORE than one of the criteria above, then:
msgbox "bla bla bla"
highlight offending cells purple
Please note that these warnings should ignore the header row (row 1) and the second row as well.
Fortunately, the data will always be in columns C, D and E due to a preceding macro that organizes the columns uniformly for future macros to work properly.
Thanks!
Bookmarks