Logic:
If "STATUS" has a value of "N" then set each cell style to 2 except the cell in first column.
Else If "STATUS" has a value of "C" then set cell style to 1 except the first cell in first column. Also ignore, (don't display), values in cells "ORDER" and "INCORDER".
Else If "INCORDER" has the value of "Y" then set cell style in "ORDER" to 2.
Else If cell has a value then set the cell style to 3 otherwise set the cell style to 4.

I haven't posted the code for the cell border converter as i think you get the idea. If you would like to see it then let me know and I will post it. Also if you need a better explanation as to when the above is doing or if there
is something missing or you have other questions then just me know and I will see if I can help :-D