¦b¼¶¼g±ø¥ó¦¡®æ¦¡¤Æ¤½¦¡®É¡A±z¥i¯à·|·Q¥Î [¨ç¦¡] ¾ðª¬µ²ºc¤WºÝªºÃB¥~¨ç¦¡¡C
½d¨Ò
¦pªGn®æ¦¡¤Æ {«È¤á.¥h¦~·~ÁZ} Äæ¦ì¡A¥Hºñ¦âÅã¥Ü¶W¹L $100,000 ªº¾P°â¶q¡A¥H¬õ¦âÅã¥Ü§C©ó $15,000 ªº¾P°â¶q¡A¦Ó¨ä¥L«h¥H¶Â¦âÅã¥Ü¡C
Rem ±ø¥ó®æ¦¡½d¨Ò 1 If {«È¤á.¥h¦~·~ÁZ} > 100000 Then formula = crGreen ElseIf {«È¤á.¥h¦~·~ÁZ} < 15000 Then formula = crRed Else formula = crBlack End If
¥Ñ©ó³o¬O¤@Ó¦r«¬¦â±m®æ¦¡¤Æªº¨ç¦¡¡A¦]¦¹¦â±m±`¼Æªº²M³æ·|¥X²{¦b [¨ç¦¡] ¾ðª¬µ²ºc¤¤¡C³oÓ½d¨Ò¨Ï¥Î¨ì¤TºØ¨ç¦¡¡GcrGreen¡BcrRed ¤Î crBlack¡C±z¤]¥i¥H§ï¥Î¦â±m±`¼Æªº¹ê»Ú¼ÆÈ¡C¨Ò¦p¡AcrRed ¬O 255¡AcrGreen ¬O 32768¡C¤£¹L¡A¨Ï¥Î¦â±m±`¼Æ·|¨Ï±o¤½¦¡§ó®e©ö²z¸Ñ¡C©Ò¦³ Basic »yªk¤¤ªº±`¼Æ¨ç¦¡³£¦³«e¸m¦r¤¸ cr¡C
ª`·N ¦³¨Ç®æ¦¡¤ÆÄݩʨ䣨ϥα`¼Æ¨ç¦¡¡C¨Ò¦p¡A¦pªG±z¤£n¦L¥X¾P°â¶q§C©ó $50,000 ªº {«È¤á.¥h¦~·~ÁZ} È¡A¥i¥H¼¶¼g¥H¤U±ø¥ó¦¡®æ¦¡¤Æ¤½¦¡¨Ó§í¨îÄݩʡG
Rem Conditional formatting example 2 If {«È¤á.¥h¦~·~ÁZ} < 50000 Then formula = True '§í¨î¼ÆÈ Else formula = False '¤£§í¨î¼ÆÈ End If
©Î¥Î§ó²³æªº¤èªk¡G
Rem ±ø¥ó®æ¦¡½d¨Ò 3 - Rem µ¥©ó½d¨Ò 2 formula = {«È¤á.¥h¦~·~ÁZ} < 50000
¦pªG¥h¦~·~ÁZ§C©ó $50,000¡A«h¹Bºâ¦¡
{«È¤á.¥h¦~·~ÁZ} < 50000
¬° True¡A¤½¦¡¤]·|¶Ç¦^ True¡C¬Û¤Ï¦a¡A¦pªG¥h¦~·~ÁZ°ª©ó©Îµ¥©ó $50,000¡A¨º»ò
{«È¤á.¥h¦~·~ÁZ} < 50000
¬° False¡A¤½¦¡¤]·|¶Ç¦^ False¡C