X

FileMakerで複数条件により条件付き書式を設定する方法

<p><iframe width&equals;"300" height&equals;"150" style&equals;"width&colon; 120px&semi; height&colon; 240px&semi;" marginwidth&equals;"0" marginheight&equals;"0" scrolling&equals;"no" frameborder&equals;"0" src&equals;"&sol;&sol;rcm-fe&period;amazon-adsystem&period;com&sol;e&sol;cm&quest;lt1&equals;&lowbar;blank&amp&semi;bc1&equals;000000&amp&semi;IS2&equals;1&amp&semi;bg1&equals;FFFFFF&amp&semi;fc1&equals;000000&amp&semi;lc1&equals;0000FF&amp&semi;t&equals;bacque-22&amp&semi;o&equals;9&amp&semi;p&equals;8&amp&semi;l&equals;as4&amp&semi;m&equals;amazon&amp&semi;f&equals;ifr&amp&semi;ref&equals;as&lowbar;ss&lowbar;li&lowbar;til&amp&semi;asins&equals;B01FGRY9IA&amp&semi;linkId&equals;8fef5b82f4069883c8c6826211e555b8"><&sol;iframe><iframe style&equals;"width&colon;120px&semi;height&colon;240px&semi;" marginwidth&equals;"0" marginheight&equals;"0" scrolling&equals;"no" frameborder&equals;"0" src&equals;"&sol;&sol;rcm-fe&period;amazon-adsystem&period;com&sol;e&sol;cm&quest;lt1&equals;&lowbar;blank&&num;038&semi;bc1&equals;000000&&num;038&semi;IS2&equals;1&&num;038&semi;bg1&equals;FFFFFF&&num;038&semi;fc1&equals;000000&&num;038&semi;lc1&equals;0000FF&&num;038&semi;t&equals;bacque-22&&num;038&semi;o&equals;9&&num;038&semi;p&equals;8&&num;038&semi;l&equals;as4&&num;038&semi;m&equals;amazon&&num;038&semi;f&equals;ifr&&num;038&semi;ref&equals;as&lowbar;ss&lowbar;li&lowbar;til&&num;038&semi;asins&equals;B071Z17R65&&num;038&semi;linkId&equals;172b76c22c7b097dc1c8393989912e2e"><&sol;iframe><br &sol;>&NewLine;FileMakerの「条件付き書式設定」は条件により自動で書式を変更することができ重宝しています。条件が真の場合は1、偽の場合は0を返し、真1の場合にフォント色、背景色他を設定するだけで自動で書式が変わってくれます。<&sol;p>&NewLine;<p>条件1、条件2,条件3・・・のように複数条件により書式を変更することも可能です。Case文のようにCase(条件1;結果1;条件2;結果2、・・・・・)のように書式変更できるわけですね。<&sol;p>&NewLine;<p>下の電子カルテで初診院により「美容外科初診カルテ」の背景色を変更する方法について考えてみましょう。<&sol;p>&NewLine;<p>初診院が<&sol;p>&NewLine;<ul>&NewLine;<li>浦和なら背景色をピンク<&sol;li>&NewLine;<li>岩槻なら背景色を緑<&sol;li>&NewLine;<li>新宿なら背景色を青<&sol;li>&NewLine;<&sol;ul>&NewLine;<p>と背景色が動的に変化するように設定してみましょう。<&sol;p>&NewLine;<p>&nbsp&semi;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;266ea6de9b3e9dfe9cd42caf815c660a&period;jpg"><img data-attachment-id&equals;"7461" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;266ea6de9b3e9dfe9cd42caf815c660a&period;jpg&quest;fit&equals;535&percnt;2C230&amp&semi;ssl&equals;1" data-orig-size&equals;"535&comma;230" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;092346&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;266ea6de9b3e9dfe9cd42caf815c660a&period;jpg&quest;fit&equals;400&percnt;2C172&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;266ea6de9b3e9dfe9cd42caf815c660a&period;jpg&quest;fit&equals;535&percnt;2C230&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7461" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;266ea6de9b3e9dfe9cd42caf815c660a-400x172&period;jpg" alt&equals;"" width&equals;"400" height&equals;"172" &sol;><&sol;a> <a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;b06f3b256cefe4f7bb7f13a923a3cc27&period;jpg"><img data-attachment-id&equals;"7462" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;b06f3b256cefe4f7bb7f13a923a3cc27&period;jpg&quest;fit&equals;527&percnt;2C231&amp&semi;ssl&equals;1" data-orig-size&equals;"527&comma;231" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;092429&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;b06f3b256cefe4f7bb7f13a923a3cc27&period;jpg&quest;fit&equals;400&percnt;2C175&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;b06f3b256cefe4f7bb7f13a923a3cc27&period;jpg&quest;fit&equals;527&percnt;2C231&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7462" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;b06f3b256cefe4f7bb7f13a923a3cc27-400x175&period;jpg" alt&equals;"" width&equals;"400" height&equals;"175" &sol;><&sol;a> <a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;c0a6c47d3eaf391daea22e8e97c3313d&period;jpg"><img data-attachment-id&equals;"7463" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;c0a6c47d3eaf391daea22e8e97c3313d&period;jpg&quest;fit&equals;532&percnt;2C233&amp&semi;ssl&equals;1" data-orig-size&equals;"532&comma;233" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;092445&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;c0a6c47d3eaf391daea22e8e97c3313d&period;jpg&quest;fit&equals;400&percnt;2C175&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;c0a6c47d3eaf391daea22e8e97c3313d&period;jpg&quest;fit&equals;532&percnt;2C233&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7463" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;c0a6c47d3eaf391daea22e8e97c3313d-400x175&period;jpg" alt&equals;"" width&equals;"400" height&equals;"175" &sol;><&sol;a><&sol;p>&NewLine;<h3>条件付き書式を使わないで複数条件により書式を変える方法<&sol;h3>&NewLine;<p>別ファイルもしくは別テーブルで「色リスト」を作成。その中に分院別色リストフィールド(オブジェクト)を作成。[オプション]をクリックして、複数の色が入れられるように設定します。<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;14e7f501f14e51d7a2b7971ad442b59f&period;jpg"><img data-attachment-id&equals;"7464" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;14e7f501f14e51d7a2b7971ad442b59f&period;jpg&quest;fit&equals;535&percnt;2C400&amp&semi;ssl&equals;1" data-orig-size&equals;"535&comma;400" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;092630&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;14e7f501f14e51d7a2b7971ad442b59f&period;jpg&quest;fit&equals;400&percnt;2C299&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;14e7f501f14e51d7a2b7971ad442b59f&period;jpg&quest;fit&equals;535&percnt;2C400&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7464" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;14e7f501f14e51d7a2b7971ad442b59f-400x299&period;jpg" alt&equals;"" width&equals;"400" height&equals;"299" &sol;><&sol;a><&sol;p>&NewLine;<p>[データの格納]で繰り返しの最大繰り返し数を設定。必要な色は3つですが、今回は5を設定。<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;da385a285c4bd5f229aee9cb94243290&period;jpg"><img data-attachment-id&equals;"7465" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;da385a285c4bd5f229aee9cb94243290&period;jpg&quest;fit&equals;286&percnt;2C400&amp&semi;ssl&equals;1" data-orig-size&equals;"286&comma;400" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;092631&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;da385a285c4bd5f229aee9cb94243290&period;jpg&quest;fit&equals;286&percnt;2C400&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;da385a285c4bd5f229aee9cb94243290&period;jpg&quest;fit&equals;286&percnt;2C400&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7465" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;da385a285c4bd5f229aee9cb94243290-286x400&period;jpg" alt&equals;"" width&equals;"286" height&equals;"400" &sol;><&sol;a><&sol;p>&NewLine;<p>色リストのデータは1枚だけのデータを作るだけ。分院別色リストのフィールドに<&sol;p>&NewLine;<ul>&NewLine;<li>岩槻1&srarr;緑のグラフィック<&sol;li>&NewLine;<li>新宿2&srarr;青のグラフィック<&sol;li>&NewLine;<li>浦和3&srarr;ピンクのグラフィック<&sol;li>&NewLine;<&sol;ul>&NewLine;<p>を収納しておきます。<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;71ce317de7d327a20248a0f1972b06b1&period;jpg"><img data-attachment-id&equals;"7466" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;71ce317de7d327a20248a0f1972b06b1&period;jpg&quest;fit&equals;600&percnt;2C395&amp&semi;ssl&equals;1" data-orig-size&equals;"600&comma;395" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;092635&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;71ce317de7d327a20248a0f1972b06b1&period;jpg&quest;fit&equals;400&percnt;2C263&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;71ce317de7d327a20248a0f1972b06b1&period;jpg&quest;fit&equals;600&percnt;2C395&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7466" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;71ce317de7d327a20248a0f1972b06b1-400x263&period;jpg" alt&equals;"" width&equals;"400" height&equals;"263" &sol;><&sol;a><&sol;p>&NewLine;<p>元のファイルで背景色というフィールドを作成、計算フィールドにします。Case文で<&sol;p>&NewLine;<p>Case&lpar;初診院=”岩槻”&semi;GetRepetition&lpar;JM色リスト&colon;&colon;分院別色リスト&colon;1&rpar;&semi;初診院=”新宿”&semi;GetRepetition&lpar;JM色リスト&colon;&colon;分院別色リスト&semi;2&rpar;&semi;初診院=”浦和”&semi;GetRepetition&lpar;JM色リスト&colon;&colon;分院別色リスト&semi;3&rpar;<&sol;p>&NewLine;<p>のように設定。<&sol;p>&NewLine;<ul>&NewLine;<li>初診院が岩槻&srarr;色リストの中の分院別色リストの1番目の色を取得<&sol;li>&NewLine;<li>初診院が新宿&srarr;色リストの中の分院別色リストの2番目の色を取得<&sol;li>&NewLine;<li>初診院が浦和&srarr;色リストの中の分院別色リストの3番目の色を取得<&sol;li>&NewLine;<&sol;ul>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;90f7bb513387e9888a16c51b4d526a84&period;jpg"><img data-attachment-id&equals;"7467" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;90f7bb513387e9888a16c51b4d526a84&period;jpg&quest;fit&equals;600&percnt;2C320&amp&semi;ssl&equals;1" data-orig-size&equals;"600&comma;320" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;092638&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;90f7bb513387e9888a16c51b4d526a84&period;jpg&quest;fit&equals;400&percnt;2C213&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;90f7bb513387e9888a16c51b4d526a84&period;jpg&quest;fit&equals;600&percnt;2C320&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7467" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;90f7bb513387e9888a16c51b4d526a84-400x213&period;jpg" alt&equals;"" width&equals;"400" height&equals;"213" &sol;><&sol;a><&sol;p>&NewLine;<p>このように設定した背景色フィールドを美容外科初診カルテのところに重ね合わせれば完了。<&sol;p>&NewLine;<h3>条件付き書式設定で複数条件がある場合の設定<&sol;h3>&NewLine;<p>条件付き書式設定ではフィールドだけではなく、テキストも設定可能になっています。美容外科初診カルテというテキストを選択して、右クリック>[条件付き書式]を選択<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;d68d63a847c1921cd57296521b0c1cae&period;jpg"><img data-attachment-id&equals;"7468" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;d68d63a847c1921cd57296521b0c1cae&period;jpg&quest;fit&equals;566&percnt;2C425&amp&semi;ssl&equals;1" data-orig-size&equals;"566&comma;425" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;171318&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;d68d63a847c1921cd57296521b0c1cae&period;jpg&quest;fit&equals;400&percnt;2C300&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;d68d63a847c1921cd57296521b0c1cae&period;jpg&quest;fit&equals;566&percnt;2C425&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7468" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;d68d63a847c1921cd57296521b0c1cae-400x300&period;jpg" alt&equals;"" width&equals;"400" height&equals;"300" &sol;><&sol;a><&sol;p>&NewLine;<p>[追加]をクリックして、条件を設定。<&sol;p>&NewLine;<ul>&NewLine;<li>計算式が・・・初診院=”浦和”&srarr;書式で文字色、塗りつぶし色を設定<&sol;li>&NewLine;<li>計算式が・・・初診院=”新宿”&srarr;書式で文字色、塗りつぶし色を設定<&sol;li>&NewLine;<li>計算式が・・・初診院=”岩槻”&srarr;書式で文字色、塗りつぶし色を設定<&sol;li>&NewLine;<&sol;ul>&NewLine;<p>&nbsp&semi;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;91a0773ab2e0cef7526af841c6e54cec&period;jpg"><img data-attachment-id&equals;"7469" data-permalink&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;archives&sol;7459&sol;attachment-0" data-orig-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;91a0773ab2e0cef7526af841c6e54cec&period;jpg&quest;fit&equals;483&percnt;2C400&amp&semi;ssl&equals;1" data-orig-size&equals;"483&comma;400" data-comments-opened&equals;"1" data-image-meta&equals;"&lbrace;&quot&semi;aperture&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;credit&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;camera&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;caption&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;created&lowbar;timestamp&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;copyright&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;focal&lowbar;length&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;iso&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;shutter&lowbar;speed&quot&semi;&colon;&quot&semi;0&quot&semi;&comma;&quot&semi;title&quot&semi;&colon;&quot&semi;&quot&semi;&comma;&quot&semi;orientation&quot&semi;&colon;&quot&semi;0&quot&semi;&rcub;" data-image-title&equals;"20170619&lowbar;171334&lowbar;条件付き書式複数条件" data-image-description&equals;"" data-image-caption&equals;"" data-medium-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;91a0773ab2e0cef7526af841c6e54cec&period;jpg&quest;fit&equals;400&percnt;2C331&amp&semi;ssl&equals;1" data-large-file&equals;"https&colon;&sol;&sol;i0&period;wp&period;com&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;91a0773ab2e0cef7526af841c6e54cec&period;jpg&quest;fit&equals;483&percnt;2C400&amp&semi;ssl&equals;1" class&equals;"alignnone size-medium wp-image-7469" src&equals;"https&colon;&sol;&sol;bacque&period;biz&sol;wp-content&sol;uploads&sol;2017&sol;06&sol;91a0773ab2e0cef7526af841c6e54cec-400x331&period;jpg" alt&equals;"" width&equals;"400" height&equals;"331" &sol;><&sol;a><&sol;p>&NewLine;<p>以上で複数条件により書式が自動で変わるようになりました。<&sol;p>&NewLine;

管理人: