Conditional formating or formula

Hello
I have this invoice spreadsheet that is populated from my timesheet. ,the way it is now it takes total billed hrs that are in column J and copies them in column W.It copies the occupation from culumb B and puts in columb v and all the billed hours go in their corresponding cells This works fine but when I just have contract hours for that occupation I want columb v blank as it is now it will show a 0 in the hours column W. In other words I don’t want any contract hours to show up on the invoice even as zero. Is there a way that I can blank out that whole row if 0 is present in (eg )(t 23)(v 23)(w23)(x23)(y 23)all would be blank because there is a 0 in cell( w23),or would it be better to do it with a formula. I Would appreciate any help and have attached a sample file to make it a little clearer. Thanks in advance

Hi,

You have identified the solution in your question. Use conditional formatting.

In T22 use the "Use a formula to determine which cell to format", and set the conditional formula to =W22=0, and set the font colour to white. Copy T22 and use paste special formats to copy it to all your other rows and columns.

Rgds