question about a simple vba code

[ccsmile]

Hey, I have a question about how to write a vba program to realize such results:
I have two columns, one is the product name, another is the product price. For those rows with missing values in the second column, I need excel to color the corresponding first column with red automatically. Could u tell me how to write this simple vba code?

Hope I express the problem clearly. Thanks very much!

 

[Rick Rothstein]

Sub ColorColumnAforMissingPricesInColumnB()
  Const DataStartRow As Long = 1
  Cells(DataStartRow, "B").Resize(Cells(Rows.Count, "A").End(xlUp).Row - DataStartRow + 1).SpecialCells(xlCellTypeBlanks).Offset(, -1).Interior.ColorIndex = 6
End Sub

Hey, thanks a lot for your anwers!
Could I ask a little bit more specific, because my data set is much complicated than I described, so I need to understand the code at first.
Could u tell me what does the first row and the second row in your code refer to?
I mean, is the first row meaning assign a constant value?
what does DataStartRow refer to?
What does End.(xlUp) mean?

A constant is like a variable except that you cannot change its value once it has been set (a variable, on the other hand, can be changed as many times as desired). The End property is the code equivalent of hitting the END key followed by one of the arrow keys. The cell it is a property of is the starting point (active cell in the keystroke equivalency) for the action. So, the starting point was specified as Cells(Rows.Count,"A")... Rows.Count is the number of rows on a worksheet (65000+ for XL2003 and earlier, 1,000,000+ for XL2007 and above), Cells(Rows.Count,"A").End(xlUp) is the same as starting from the bottom of Column A and hitting the END key followed by the Up arrow... it finds the last cell in the column with data in it.

 

[Rick Rothstein]

Could I ask a little bit more specific, because my data set is much complicated than I described...

Simplifying your data structure for us is usually a bad idea as it tends to get you answers to a question you really do not care about and that, as you see, are not always easy to expand to cover your actual situation.