Need to Mod Code on red text, I have VBA to distinguish Paid(Black Text) Unpaid(Red Text)

A few users on here have been of great help with this program, My current problem with it as I would like to pre set all the cells in my customer list to red text, and as they pay me I will turn those cells to black text. As it sits if they cells are marked with red text but are blank cells if I click the invoice it will show up the month but to price, because that cell is blank. I would like it to look into the cell first and if there is no typed value in the cell to over look. I hope that it makes since to you guys. thanks again for the help

Test 1.xls

Link to the other post

[Solved] VBA Code x2 i have a code i want to duplicate in another cell on the same page
http://www.excelforum.com/excel-prog...ml#post3523669

Macros Print multiple invoice Generator 2 different customers per single page Odd/Even num
http://www.excelforum.com/excel-prog...ml#post3523418

(Solved) I need a VBA to distinguish Paid(Black Text) Unpaid(Red Text)
http://www.excelforum.com/excel-prog...ml#post3520932

I want all to red text on start, and as payment comes in they go to black. The problem is if the cell is empty but is set to red text that cell shows up on invoice, with a blank price, the coding i need help with is within the invoice.

I will explain it a lot better, on sheet 3(sum) I have a list of customers, to the right of each customer is a list of 12 months, each month will have a price owed when the month hits. If the price (text) is in black the customer has already paid, if the price (text) is red the customer owes. before I import the prices I would like the cells to be set to red text from the beginning and as I need to mark paid(change to black text) I will.

The problem is if the empty cells are preset to red text, when you go to the sheet 2(Invoice) or 4(Invoice_Single_Sheet) select a customer from the drop down, it will show each month that is pre set to red text, the month will show up in the invoice but no price because there is nothing owed.

I would like it to be if the sum sheet has a blank cell weather is be red text or black text pre set, it only shows up on the invoice sheet if there is an amount listed.

its not something that is part of a macro, its more vba in the coding of the invoice sheets

quick update to the file to show how sheet(sum) cells C5:D9 are preset to font color red
sheet(Invoice) if you notice it lists months collected (December,November) but blank total because billing was not done for those months.
so when ever a customer is slected those months show up but are not needed.

the vba code it in the invoice sheet created by a few users on here. thanks again as it was great. something is needed I'm just not sure what wording is needed to make the blanks go away.

Test 1.xls

Solved on this post

http://www.excelforum.com/excel-prog...o-my-code.html