I thought I could get away with a custom cell format to accomplish this but it doesn't appear that it will work that way.
This is the code I tried to do this with:
<font face=Courier New><SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> c <SPAN style="color:#00007F">In</SPAN> Range("D:D")
<SPAN style="color:#00007F">If</SPAN> c.Value = "Total" <SPAN style="color:#00007F">Then</SPAN>
c.Offset(0, 1) = Format(Cells(c.Row, "b"), "# ##/##") & " x " & Format(Cells(c.Row, "c"), "# ##/##")
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
<SPAN style="color:#00007F">Next</SPAN> c</FONT>
But I am not ending with fractions so obviously my formatting is incorrect.
Any input would be appreciated
This is the code I tried to do this with:
<font face=Courier New><SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> c <SPAN style="color:#00007F">In</SPAN> Range("D:D")
<SPAN style="color:#00007F">If</SPAN> c.Value = "Total" <SPAN style="color:#00007F">Then</SPAN>
c.Offset(0, 1) = Format(Cells(c.Row, "b"), "# ##/##") & " x " & Format(Cells(c.Row, "c"), "# ##/##")
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
<SPAN style="color:#00007F">Next</SPAN> c</FONT>
But I am not ending with fractions so obviously my formatting is incorrect.
Any input would be appreciated