軟體: excel
版本: 2010
A1 = IF(sheet1!G14="","",sheet1!G14 & " + " ) &
IF(sheet1!H14<>"","(" & sheet1!H14 & ")" & sheet1!J14,"")
前半部想要用黑色字 IF(sheet1!G14="","",sheet1!G14&" + ") &
前半部想要用紅色字 IF(sheet1!H14<>""," ("&sheet1!H14&") "&sheet1!J14,"")
因為這個檔案想放在雲端，請問不用VBA的話有解嗎?
謝謝大家