软件: 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的话有解吗?
谢谢大家