[TABLE="width: 500"]
[tr][td]ITEM
[/td][td]Price(Please enter Price)
[/td][/tr][tr][td]Windows
[/td][td][/td][/tr][tr][td]Doors
[/td][td][/td][/tr][tr][td]Brush
[/td][td][/td][/tr][tr]
[TD="align: center"]TOTAL[/TD]
[/TABLE]
Given the above table, i am looking for a way for the Total to sum given the inputted information above the price, but if one of the cells is left blank i want a message to appear "Please enter relevant information into ALL cells".
Any Ideas, is this even possible. i was trying something along the lines of conditional formatting but have yet to get it working correctly.