VBA Checking between two decimals

[ChippyWeek]

I have to check whether specified column's decimals are 0 or higher and smaller than a decimal from different column and one row above the current cell. Here's a picture. What would be correct way to make this using VBA?

 

[Derek73]

We can handle this different ways. Your rules are clear...C4>0 and C4>E3. But I don't understand the "what to do" if that's true. If all we want to do is flag the issue, this could be handled by an if statement...for example, insert a column at F:F, and set F4 with

=IF(AND(C4>0,C4>E3),"WARNING!","")

VBA would be useful if we wanted to do something much more specific that can't be handled with formulas....like output all the rows where there's an issue on another sheet, for example.