{"id":1332,"date":"2022-03-19T06:58:20","date_gmt":"2022-03-19T07:58:20","guid":{"rendered":"https:\/\/irtecnology.ir\/?p=1332"},"modified":"2022-03-19T06:58:23","modified_gmt":"2022-03-19T07:58:23","slug":"%d9%82%d8%a7%d9%84%d8%a8-%d8%a8%d9%86%d8%af%db%8c-%d8%b4%d8%b1%d8%b7%db%8c","status":"publish","type":"post","link":"https:\/\/irtecnology.ir\/?p=1332","title":{"rendered":"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uor6sr-f243f554795083431e5be2a38d3d9e38\">\n#top .av-special-heading.av-l0uor6sr-f243f554795083431e5be2a38d3d9e38{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-l0uor6sr-f243f554795083431e5be2a38d3d9e38 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-l0uor6sr-f243f554795083431e5be2a38d3d9e38 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-l0uor6sr-f243f554795083431e5be2a38d3d9e38 av-special-heading-h3 blockquote modern-quote modern-centered  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h3 class='av-special-heading-tag '  itemprop=\"headline\"  >\u0622\u0645\u0648\u0632\u0634 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<section  class='av_textblock_section av-l0uot3pe-60d3d87873eb6fc939a1d30539b9f5c7 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h5><span><span class=\"goog-text-highlight\">\u0645\u0639\u0631\u0641\u06cc<\/span><\/span><\/h5>\n<p><span>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631\u06af \u0628\u0627 \u0647\u0632\u0627\u0631\u0627\u0646 \u0631\u062f\u06cc\u0641 \u062f\u0627\u062f\u0647 \u062f\u0627\u0631\u06cc\u062f.\u00a0\u0645\u0634\u0627\u0647\u062f\u0647 \u0627\u0644\u06af\u0648\u0647\u0627 \u0648 \u0631\u0648\u0646\u062f\u0647\u0627 \u0641\u0642\u0637 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0628\u0631\u0631\u0633\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062e\u0627\u0645 \u0628\u0633\u06cc\u0627\u0631 \u062f\u0634\u0648\u0627\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.\u00a0\u0634\u0628\u06cc\u0647 \u0628\u0647 \u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627 \u0648 \u062e\u0637\u0648\u0637\u060c <\/span><strong><span>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc<\/span><\/strong><span>\u00a0\u0631\u0627\u0647\u06cc \u0628\u0631\u0627\u06cc \u062a\u062c\u0633\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u062f\u0631\u06a9 \u0622\u0633\u0627\u0646\u062a\u0631 \u06a9\u0627\u0631\u0628\u0631\u06af \u0647\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f.<\/span><\/p>\n<p class=\"moreInfo\"><span>\u0627\u062e\u062a\u06cc\u0627\u0631\u06cc:\u00a0<\/span><a href=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/workfile\/21%20excel_conditionalformatting_practice.xlsx\"><span>\u06a9\u062a\u0627\u0628 \u06a9\u0627\u0631 \u062a\u0645\u0631\u06cc\u0646\u06cc<\/span><\/a><span>\u00a0\u0645\u0627 \u0631\u0627 \u062f\u0627\u0646\u0644\u0648\u062f \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n<h6><span><span class=\"goog-text-highlight\">\u062f\u0631\u06a9 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc<\/span><\/span><\/h6>\n<p><span>\u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u0631\u0627 \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 &#8211; \u0645\u0627\u0646\u0646\u062f <\/span><strong><span>\u0631\u0646\u06af\u200c\u0647\u0627<\/span><\/strong><span>\u00a0\u060c\u00a0<\/span><strong><span>\u0646\u0645\u0627\u062f\u0647\u0627<\/span><\/strong><span>\u00a0\u0648\u00a0<\/span><strong><span>\u0646\u0648\u0627\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647<\/span><\/strong><span>\u00a0&#8211; \u0628\u0631 \u0627\u0633\u0627\u0633\u00a0<strong>\u0645\u0642\u062f\u0627\u0631\u00a0<\/strong><\/span><strong><span>\u0633\u0644\u0648\u0644<\/span><\/strong>\u00a0<span>\u062f\u0631 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0633\u0644\u0648\u0644 \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f .\u00a0\u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u0628\u0627\u06cc\u062f \u06cc\u06a9\u00a0<strong>\u0642\u0627\u0646\u0648\u0646\u00a0<\/strong><strong>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc<\/strong> \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.\u00a0\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u06cc\u06a9 \u0642\u0627\u0646\u0648\u0646 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u06cc\u0646 \u0628\u0627\u0634\u062f:\u00a0<strong>\u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 \u06a9\u0645\u062a\u0631 \u0627\u0632 2000 \u062f\u0644\u0627\u0631 \u0627\u0633\u062a\u060c \u0633\u0644\u0648\u0644 \u0631\u0627 \u0642\u0631\u0645\u0632 \u0631\u0646\u06af<\/strong>\u00a0\u06a9\u0646\u06cc\u062f.\u00a0\u0628\u0627 \u0627\u0639\u0645\u0627\u0644 \u0627\u06cc\u0646 \u0642\u0627\u0646\u0648\u0646\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0633\u0631\u0639\u062a \u0628\u0628\u06cc\u0646\u06cc\u062f \u06a9\u062f\u0627\u0645 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u062d\u0627\u0648\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u06a9\u0645\u062a\u0631 \u0627\u0632 2000 \u062f\u0644\u0627\u0631 \u0647\u0633\u062a\u0646\u062f.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uotej5-6052f3de6cf734902dfc6d8d7bfd7eb0\">\n#top .hr.hr-invisible.av-l0uotej5-6052f3de6cf734902dfc6d8d7bfd7eb0{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uotej5-6052f3de6cf734902dfc6d8d7bfd7eb0 hr-invisible  avia-builder-el-2  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uuyea6-d8a4c13f134e9c986fccba690a79330f '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/442%20conditional_formatting_understanding.png\" alt=\"\u062f\u0631\u06a9 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"667\" height=\"275\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uotk21-ffb344b1665c8da17af8c48dd2a7eba6\">\n#top .hr.hr-invisible.av-l0uotk21-ffb344b1665c8da17af8c48dd2a7eba6{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uotk21-ffb344b1665c8da17af8c48dd2a7eba6 hr-invisible  avia-builder-el-4  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uou7fh-dec2dd540503487e840c4024da7b4ae6 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h6><span>\u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0642\u0627\u0646\u0648\u0646 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc:<\/span><\/h6>\n<p><span>\u062f\u0631 \u0645\u062b\u0627\u0644 \u062e\u0648\u062f\u060c \u0645\u0627 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631\u06af \u062d\u0627\u0648\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0641\u0631\u0648\u0634 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0628\u06cc\u0646\u06cc\u0645 \u06a9\u062f\u0627\u0645 \u0641\u0631\u0648\u0634\u0646\u062f\u0647\u200c\u0647\u0627 \u0627\u0647\u062f\u0627\u0641 \u0641\u0631\u0648\u0634 \u0645\u0627\u0647\u0627\u0646\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f.\u00a0\u0647\u062f\u0641 \u0641\u0631\u0648\u0634 4000 \u062f\u0644\u0627\u0631 \u062f\u0631 \u0645\u0627\u0647 \u0627\u0633\u062a\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u06cc\u06a9 \u0642\u0627\u0646\u0648\u0646 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0645\u0634\u0631\u0648\u0637 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0633\u0644\u0648\u0644\u06cc \u06a9\u0647 \u062f\u0627\u0631\u0627\u06cc \u0645\u0642\u062f\u0627\u0631 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 4000 \u0628\u0627\u0634\u062f \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/span><\/p>\n<ol class=\"numbered-list\">\n<li><strong><span>\u0633\u0644\u0648\u0644 \u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627<\/span><\/strong><span>\u00a0\u0628\u0631\u0627\u06cc \u0642\u0627\u0646\u0648\u0646 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\u00a0\u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<\/ol>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uoug7o-c34ba322ce4c2f58b6d0ddc706caf61f\">\n#top .hr.hr-invisible.av-l0uoug7o-c34ba322ce4c2f58b6d0ddc706caf61f{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uoug7o-c34ba322ce4c2f58b6d0ddc706caf61f hr-invisible  avia-builder-el-6  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uuz29m-ab7a0e15b035a6d7877a83042b739e32 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/443%20conditional_formatting_create_select.png\" alt=\"\u0627\u06cc\u062c\u0627\u062f \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"895\" height=\"568\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uoukzr-3583083c576e24bd7bb70ebc65c9e5c9\">\n#top .hr.hr-invisible.av-l0uoukzr-3583083c576e24bd7bb70ebc65c9e5c9{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uoukzr-3583083c576e24bd7bb70ebc65c9e5c9 hr-invisible  avia-builder-el-8  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uovbnl-afe6ad232ae2807a4cb0d8a81e11d865 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 2. \u0627\u0632 <\/span><span class=\"goog-text-highlight\">\u062a\u0628\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">Home \u0631\u0648\u06cc \u062f\u0633\u062a\u0648\u0631\u00a0<\/span><\/span><\/strong><strong><span><span class=\"goog-text-highlight\">Conditional Formatting<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\"> \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.\u00a0<\/span>\u06cc\u06a9 \u0645\u0646\u0648\u06cc \u06a9\u0634\u0648\u06cc\u06cc \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/span><\/p>\n<p><span>\u00a0 \u00a0 \u00a0 3. \u0645\u0627\u0648\u0633 \u0631\u0627 \u0631\u0648\u06cc <\/span><strong><span>\u0646\u0648\u0639 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc<\/span><\/strong><span> \u062f\u0644\u062e\u0648\u0627\u0647 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f\u060c \u0633\u067e\u0633\u00a0<\/span><strong><span>\u0642\u0627\u0646\u0648\u0646 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627<\/span><\/strong><span>\u00a0\u0627\u0632 \u0645\u0646\u0648\u06cc \u0638\u0627\u0647\u0631 \u0634\u062f\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.\u00a0\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627\u060c \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645\u00a0<\/span><strong><span>\u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u00a0<\/span><\/strong><strong><span>\u0628\u0632\u0631\u06af\u200c\u062a\u0631 \u0627\u0632<\/span><\/strong><span>\u00a04000 \u062f\u0644\u0627\u0631 \u0631\u0627 \u0628\u0631\u062c\u0633\u062a\u0647\u00a0\u06a9\u0646\u06cc\u0645.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uovjg3-a8440d635ee8021d506354e44a54d296\">\n#top .hr.hr-invisible.av-l0uovjg3-a8440d635ee8021d506354e44a54d296{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uovjg3-a8440d635ee8021d506354e44a54d296 hr-invisible  avia-builder-el-10  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uuzo71-559c9f05ae9ec225bedd2eee98fdd70b '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/444%20conditional_formatting_create_menu.png\" alt=\"\u0645\u0646\u0648 \u0627\u06cc\u062c\u0627\u062f \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"369\" height=\"413\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uovqau-0ab5f8812a169d810c1fd2510b1f7ae0\">\n#top .hr.hr-invisible.av-l0uovqau-0ab5f8812a169d810c1fd2510b1f7ae0{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uovqau-0ab5f8812a169d810c1fd2510b1f7ae0 hr-invisible  avia-builder-el-12  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uox3d0-a0dc1fa90fc1f9cc57379e605b9617bb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"\">\u00a0 \u00a0 \u00a0 4. \u06cc\u06a9 \u062c\u0639\u0628\u0647 \u06af\u0641\u062a\u06af\u0648 \u0638\u0627\u0647\u0631 \u062e\u0648\u0627\u0647\u062f \u0634\u062f. <\/span><\/span><strong><span>\u0645\u0642\u062f\u0627\u0631(\u0647\u0627\u06cc) \u0645\u0648\u0631\u062f \u0646\u0638\u0631<\/span><\/strong><span>\u00a0\u0631\u0627 \u062f\u0631 \u0641\u06cc\u0644\u062f \u062e\u0627\u0644\u06cc\u00a0\u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.\u00a0\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627 4000 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u0642\u062f\u0627\u0631 \u0648\u0627\u0631\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/span><\/p>\n<p><span>\u00a0 \u00a0 \u00a0 5. \u06cc\u06a9 <strong>\u0633\u0628\u06a9\u00a0<\/strong><\/span><strong><span>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc<\/span><\/strong>\u00a0<span>\u0631\u0627 \u0627\u0632 \u0645\u0646\u0648\u06cc \u06a9\u0634\u0648\u06cc\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.\u00a0\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627\u060c <strong>Green Fill with Dark Green Text<\/strong>\u00a0\u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc \u06a9\u0646\u06cc\u0645\u060c \u0633\u067e\u0633 \u0631\u0648\u06cc\u00a0<strong>OK<\/strong>\u00a0\u06a9\u0644\u06cc\u06a9 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uoxcb3-d0c21d570355bb592734b4955cf14438\">\n#top .hr.hr-invisible.av-l0uoxcb3-d0c21d570355bb592734b4955cf14438{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uoxcb3-d0c21d570355bb592734b4955cf14438 hr-invisible  avia-builder-el-14  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv0b4v-508046db99f17ef99c6e641535622eed '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/445%20conditional_formatting_create_dialog.png\" alt=\"\u06a9\u0627\u062f\u0631 \u0645\u062d\u0627\u0648\u0631\u0647 \u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"471\" height=\"133\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uoxgw9-b30e7fac215f9d2fa5ec58f542576a66\">\n#top .hr.hr-invisible.av-l0uoxgw9-b30e7fac215f9d2fa5ec58f542576a66{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uoxgw9-b30e7fac215f9d2fa5ec58f542576a66 hr-invisible  avia-builder-el-16  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uoy077-1871df24c90a14dbff30b5d24d554bfa '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 6. \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0628\u0631\u0627\u06cc \u0633\u0644\u0648\u0644 \u0647\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u062f\u0647 \u0627\u0639\u0645\u0627\u0644 \u062e\u0648\u0627\u0647\u062f \u0634\u062f. <\/span>\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627\u060c \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646 \u062f\u06cc\u062f \u06a9\u0647 \u06a9\u062f\u0627\u0645 \u0641\u0631\u0648\u0634\u0646\u062f\u0647 \u0628\u0647 \u0647\u062f\u0641 \u0641\u0631\u0648\u0634 4000 \u062f\u0644\u0627\u0631 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0645\u0627\u0647 \u0631\u0633\u06cc\u062f\u0647 \u0627\u0633\u062a.<\/span><\/p>\n<div class=\"centerImage\"><\/div>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uoy9iw-0cab5f6f426700a837295234b9219411\">\n#top .hr.hr-invisible.av-l0uoy9iw-0cab5f6f426700a837295234b9219411{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uoy9iw-0cab5f6f426700a837295234b9219411 hr-invisible  avia-builder-el-18  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv12d9-34430b2b3826d1c09d5e81866259667c '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/446%20conditional_formatting_create_result.png\" alt=\"\u0646\u062a\u06cc\u062c\u0647 \u0627\u06cc\u062c\u0627\u062f \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"895\" height=\"568\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uoyf7i-42ccabad25b5054be57429655e5a946c\">\n#top .hr.hr-invisible.av-l0uoyf7i-42ccabad25b5054be57429655e5a946c{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uoyf7i-42ccabad25b5054be57429655e5a946c hr-invisible  avia-builder-el-20  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uoyqom-91302f2cb703e6b4713af980030cc0c4 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0686\u0646\u062f\u06cc\u0646 \u0642\u0627\u0646\u0648\u0646 \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u06cc \u06cc\u0627 \u06a9\u0627\u0631\u0628\u0631\u06af \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f\u060c \u06a9\u0647 \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0631\u0648\u0646\u062f\u0647\u0627 \u0648 \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0631\u0627 \u062f\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u062a\u062c\u0633\u0645 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uoyylx-6330a22046fff4327011526fed46bf8d\">\n#top .hr.hr-invisible.av-l0uoyylx-6330a22046fff4327011526fed46bf8d{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uoyylx-6330a22046fff4327011526fed46bf8d hr-invisible  avia-builder-el-22  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv1uce-345e49ad018bc4ce220d3eee28bf0426 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/447%20conditional_formatting_create_multiple.png\" alt=\"\u0627\u06cc\u062c\u0627\u062f \u0686\u0646\u062f\u06cc\u0646 \u0634\u0631\u0637 \u062f\u0631 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"895\" height=\"568\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0uoz372-178bce4d104d539a2b262001c450f8d7\">\n#top .hr.hr-invisible.av-l0uoz372-178bce4d104d539a2b262001c450f8d7{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0uoz372-178bce4d104d539a2b262001c450f8d7 hr-invisible  avia-builder-el-24  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up0u91-420bb683bb7c6086c83e45e54b939b18 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h5>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647<\/h5>\n<p>\u0627\u06a9\u0633\u0644 \u0686\u0646\u062f\u06cc\u0646 \u0633\u0628\u06a9 \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u06cc\u0627\u00a0<strong>\u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u06cc\u06cc\u0646<\/strong>\u00a0\u0634\u062f\u0647 \u062f\u0627\u0631\u062f \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0622\u0646\u0647\u0627 \u0628\u0631\u0627\u06cc \u0627\u0639\u0645\u0627\u0644 \u0633\u0631\u06cc\u0639 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0628\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.\u00a0\u0622\u0646\u0647\u0627 \u0628\u0647 \u0633\u0647 \u062f\u0633\u062a\u0647 \u062f\u0633\u062a\u0647 \u0628\u0646\u062f\u06cc \u0645\u06cc \u0634\u0648\u0646\u062f:<\/p>\n<ul>\n<li><strong>\u0646\u0648\u0627\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 (Data Bars)<\/strong>\u060c \u0645\u06cc\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0641\u0642\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0628\u0647 \u0647\u0631 \u0633\u0644\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f\u060c \u0645\u0627\u0646\u0646\u062f\u00a0<strong>\u0646\u0645\u0648\u062f\u0627\u0631 \u0645\u06cc\u0644\u0647\u200c\u0627\u06cc<\/strong>.<\/li>\n<\/ul>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up132y-bc373701869fd60d5b1406d28cd7dabc\">\n#top .hr.hr-invisible.av-l0up132y-bc373701869fd60d5b1406d28cd7dabc{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up132y-bc373701869fd60d5b1406d28cd7dabc hr-invisible  avia-builder-el-26  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv2bd5-d61e4ec0596da8d26a1558114f97ab38 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/448%20conditional_formatting_data_bars.png\" alt=\"data bars\" width=\"450\" height=\"95\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up17ck-f3447e78d6931aaa9c59988659809ad5\">\n#top .hr.hr-invisible.av-l0up17ck-f3447e78d6931aaa9c59988659809ad5{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up17ck-f3447e78d6931aaa9c59988659809ad5 hr-invisible  avia-builder-el-28  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up2bjg-077e3451ecf101dd2116e7915cb606ca '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><ul>\n<li><strong><span><span class=\"goog-text-highlight\">\u0645\u0642\u06cc\u0627\u0633<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\"> \u0647\u0627\u06cc \u0631\u0646\u06af\u06cc (<strong>Color Scales<\/strong>) \u0631\u0646\u06af \u0647\u0631 \u0633\u0644\u0648\u0644 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0642\u062f\u0627\u0631 \u0622\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u062f\u0647\u062f. <\/span>\u0647\u0631 \u0645\u0642\u06cc\u0627\u0633 \u0631\u0646\u06af\u06cc \u0627\u0632 \u06cc\u06a9\u00a0<\/span><strong><span>\u06af\u0631\u0627\u062f\u06cc\u0627\u0646 \u062f\u0648 \u06cc\u0627 \u0633\u0647 \u0631\u0646\u06af \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc<\/span><\/strong><span>\u00a0\u06a9\u0646\u062f.\u00a0\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u062f\u0631\u00a0\u0645\u0642\u06cc\u0627\u0633 \u0631\u0646\u06af\u00a0<\/span><strong><span>\u0633\u0628\u0632-\u0632\u0631\u062f-\u0642\u0631\u0645\u0632 \u060c\u00a0<\/span><\/strong><strong><span>\u0628\u0627\u0644\u0627\u062a\u0631\u06cc\u0646<\/span><\/strong><span>\u00a0\u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0628\u0632\u060c \u0645\u0642\u0627\u062f\u06cc\u0631\u00a0<\/span><strong><span>\u0645\u062a\u0648\u0633\u0637<\/span><\/strong><span>\u00a0\u200b\u200b\u0632\u0631\u062f \u0648\u00a0<\/span><strong><span>\u06a9\u0645\u062a\u0631\u06cc\u0646<\/span><\/strong><span>\u00a0\u0645\u0642\u0627\u062f\u06cc\u0631 \u0642\u0631\u0645\u0632 \u0647\u0633\u062a\u0646\u062f.<\/span><\/li>\n<\/ul>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up2p2k-2b9334311fe60c0f7ccf347c47401aac\">\n#top .hr.hr-invisible.av-l0up2p2k-2b9334311fe60c0f7ccf347c47401aac{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up2p2k-2b9334311fe60c0f7ccf347c47401aac hr-invisible  avia-builder-el-30  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv3425-bef5bf609c9365486d9a5967ab55bcb9 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/449%20conditional_formatting_color_scales.png\" alt=\"scales\" width=\"451\" height=\"95\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up2uuf-d652c97ff98ae5caafe49829facca9ed\">\n#top .hr.hr-invisible.av-l0up2uuf-d652c97ff98ae5caafe49829facca9ed{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up2uuf-d652c97ff98ae5caafe49829facca9ed hr-invisible  avia-builder-el-32  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up3oc2-9d092c62e07853356ecc445118d99779 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><ul>\n<li><strong><span>\u0645\u062c\u0645\u0648\u0639\u0647<\/span><\/strong><span> \u0622\u06cc\u06a9\u0648\u0646 \u0647\u0627 <strong>(Icon Sets)<\/strong> \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0642\u062f\u0627\u0631 \u0647\u0631 \u0633\u0644\u0648\u0644 \u06cc\u06a9 \u0646\u0645\u0627\u062f \u062e\u0627\u0635 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/span><\/li>\n<\/ul>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up407t-d158dab44896c6d773d160b951d54021\">\n#top .hr.hr-invisible.av-l0up407t-d158dab44896c6d773d160b951d54021{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up407t-d158dab44896c6d773d160b951d54021 hr-invisible  avia-builder-el-34  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv3mic-d9d5fb6bedecd64c2d7ca807e0f6586b '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/450%20conditional_formatting_icon_sets.png\" alt=\"icon sets\" width=\"450\" height=\"95\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up44rq-f141323f80dc3dd7fffc2a542d830cb3\">\n#top .hr.hr-invisible.av-l0up44rq-f141323f80dc3dd7fffc2a542d830cb3{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up44rq-f141323f80dc3dd7fffc2a542d830cb3 hr-invisible  avia-builder-el-36  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up4gri-d995c1fa4c17c4b72ffefb7bc9bfa8e6 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h6><span><span class=\"goog-text-highlight\">\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u06cc\u06cc\u0646 \u0634\u062f\u0647:<\/span><\/span><\/h6>\n<ol class=\"numbered-list\">\n<li><strong><span>\u0633\u0644\u0648\u0644 \u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627<\/span><\/strong><span>\u00a0\u0628\u0631\u0627\u06cc \u0642\u0627\u0646\u0648\u0646 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\u00a0\u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<\/ol>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up4phk-32dd705dbd26d40b60ebbbebbdf03bf4\">\n#top .hr.hr-invisible.av-l0up4phk-32dd705dbd26d40b60ebbbebbdf03bf4{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up4phk-32dd705dbd26d40b60ebbbebbdf03bf4 hr-invisible  avia-builder-el-38  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv45w5-48aa6177912e5eba240eb743e9d7829c '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/451%20conditional_formatting_preset_select.png\" alt=\"\u0627\u0646\u062a\u062e\u0627\u0628 preset\" width=\"895\" height=\"568\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up4whf-54e2a9ae99dd4c015aed0509f2848d6a\">\n#top .hr.hr-invisible.av-l0up4whf-54e2a9ae99dd4c015aed0509f2848d6a{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up4whf-54e2a9ae99dd4c015aed0509f2848d6a hr-invisible  avia-builder-el-40  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up65p5-9799057c57af9aa95d96033a8437367c '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span>\u00a0 \u00a0 \u00a0 2. \u0631\u0648\u06cc \u062f\u0633\u062a\u0648\u0631 <\/span><strong><span>Conditional Formatting<\/span><\/strong><span> \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.\u00a0\u06cc\u06a9 \u0645\u0646\u0648\u06cc \u06a9\u0634\u0648\u06cc\u06cc \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/span><\/p>\n<p><span>\u00a0 \u00a0 \u00a0 3. \u0645\u0627\u0648\u0633 \u0631\u0627 \u0631\u0648\u06cc <\/span><strong><span>\u067e\u06cc\u0634 \u062a\u0646\u0638\u06cc\u0645 \u062f\u0644\u062e\u0648\u0627\u0647 ()<\/span><\/strong><span> \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f\u060c \u0633\u067e\u0633 \u06cc\u06a9\u00a0<\/span><strong><span>\u0633\u0628\u06a9<\/span><\/strong><span>\u00a0\u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u06cc\u06cc\u0646 \u0634\u062f\u0647 \u0631\u0627 \u0627\u0632 \u0645\u0646\u0648\u06cc \u0638\u0627\u0647\u0631 \u0634\u062f\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up6d5a-54084d4a8fc4ec4d4f439de5ffeeca76\">\n#top .hr.hr-invisible.av-l0up6d5a-54084d4a8fc4ec4d4f439de5ffeeca76{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up6d5a-54084d4a8fc4ec4d4f439de5ffeeca76 hr-invisible  avia-builder-el-42  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv4rr8-f2bd68e304089c9dabefdfac9111146c '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/452%20conditional_formatting_preset_menu.png\" alt=\"\u0645\u0646\u0648 preset\" width=\"442\" height=\"682\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up6hnc-481b929b78b84a68d8a0c3275b210e68\">\n#top .hr.hr-invisible.av-l0up6hnc-481b929b78b84a68d8a0c3275b210e68{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up6hnc-481b929b78b84a68d8a0c3275b210e68 hr-invisible  avia-builder-el-44  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up6rtp-8da75cc92c530d34da0f899f262639d2 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>4. \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0628\u0631\u0627\u06cc \u0633\u0644\u0648\u0644 \u0647\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u062f\u0647 \u0627\u0639\u0645\u0627\u0644 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up6z72-136e7cbf996f90db351e77728f2ca73a\">\n#top .hr.hr-invisible.av-l0up6z72-136e7cbf996f90db351e77728f2ca73a{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up6z72-136e7cbf996f90db351e77728f2ca73a hr-invisible  avia-builder-el-46  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv5saq-19581374c6f797677915d2d5c76fc260 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/453%20conditional_formatting_preset_result.png\" alt=\"\u0646\u062a\u06cc\u062c\u0647 preset\" width=\"895\" height=\"568\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up73u8-8a818864ccfb1b167bbe4a96ef522f90\">\n#top .hr.hr-invisible.av-l0up73u8-8a818864ccfb1b167bbe4a96ef522f90{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up73u8-8a818864ccfb1b167bbe4a96ef522f90 hr-invisible  avia-builder-el-48  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up7m2v-550524fda8142b431c1d3c5fde386f88 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h5><span><span class=\"goog-text-highlight\">\u062d\u0630\u0641 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc<\/span><\/span><\/h5>\n<h6><span>\u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc:<\/span><\/h6>\n<ol class=\"numbered-list\">\n<li><span>\u0631\u0648\u06cc \u062f\u0633\u062a\u0648\u0631\u00a0<\/span><strong><span>Conditional Formatting<\/span><\/strong><span> \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.\u00a0\u06cc\u06a9 \u0645\u0646\u0648\u06cc \u06a9\u0634\u0648\u06cc\u06cc \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/span><\/li>\n<li><span>\u0645\u0627\u0648\u0633 \u0631\u0627 \u0631\u0648\u06cc\u00a0<\/span><strong><span>Clear Rules<\/span><\/strong><span> \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f\u060c \u0633\u067e\u0633 \u0642\u0648\u0627\u0646\u06cc\u0646\u06cc \u0631\u0627 \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u067e\u0627\u06a9 \u06a9\u0646\u06cc\u062f \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.\u00a0\u062f\u0631 \u0645\u062b\u0627\u0644 \u062e\u0648\u062f\u060c\u00a0<\/span><strong><span>Clear Rules \u0631\u0627 \u0627\u0632 Entire Sheet<\/span><\/strong><span>\u00a0\u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u062a\u0627 \u0647\u0645\u0647 \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc\u200c\u0647\u0627\u06cc \u0634\u0631\u0637\u06cc \u0631\u0627 \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u06af \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645.<\/span><\/li>\n<\/ol>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up7tww-c7dd7ea04c867b6337c9820be15f40ed\">\n#top .hr.hr-invisible.av-l0up7tww-c7dd7ea04c867b6337c9820be15f40ed{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up7tww-c7dd7ea04c867b6337c9820be15f40ed hr-invisible  avia-builder-el-50  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv6ej2-feb9f49a0a4b1f23007a24cbb9efc869 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/454%20conditional_formatting_remove_menu.png\" alt=\"\u0645\u0646\u0648 \u062d\u0630\u0641 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"414\" height=\"422\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up7yi7-9cd1754e62ad525668000535a056192b\">\n#top .hr.hr-invisible.av-l0up7yi7-9cd1754e62ad525668000535a056192b{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up7yi7-9cd1754e62ad525668000535a056192b hr-invisible  avia-builder-el-52  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up88t9-2f0ce2ea109a933080cb540787d82ffb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>3. \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0645\u0634\u0631\u0648\u0637 \u062d\u0630\u0641 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up8gkg-dec2a06dc8304b3f4f8aabe71bcf428a\">\n#top .hr.hr-invisible.av-l0up8gkg-dec2a06dc8304b3f4f8aabe71bcf428a{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up8gkg-dec2a06dc8304b3f4f8aabe71bcf428a hr-invisible  avia-builder-el-54  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv6xof-32530c064d05593e52652bc74965f3df '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/455%20conditional_formatting_remove_result.png\" alt=\"\u0646\u062a\u06cc\u062c\u0647 \u062d\u0630\u0641 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"895\" height=\"568\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up8kt6-97c10c53d72d300cf6175b3f01f3a5ec\">\n#top .hr.hr-invisible.av-l0up8kt6-97c10c53d72d300cf6175b3f01f3a5ec{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up8kt6-97c10c53d72d300cf6175b3f01f3a5ec hr-invisible  avia-builder-el-56  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0up8x76-a89b12263ff0aefa8513bf017720e223 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span>\u0628\u0631\u0627\u06cc \u0648\u06cc\u0631\u0627\u06cc\u0634 \u06cc\u0627 \u062d\u0630\u0641\u00a0\u0642\u0648\u0627\u0646\u06cc\u0646\u00a0<strong>\u0641\u0631\u062f\u06cc<\/strong>\u060c \u0631\u0648\u06cc\u00a0<\/span><strong><span>Manage Rules \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.\u00a0<\/span><\/strong><span>\u0627\u06cc\u0646 \u0628\u0647 \u0648\u06cc\u0698\u0647 \u062f\u0631 \u0635\u0648\u0631\u062a\u06cc \u0645\u0641\u06cc\u062f \u0627\u0633\u062a \u06a9\u0647\u00a0<strong>\u0686\u0646\u062f\u06cc\u0646 \u0642\u0627\u0646\u0648\u0646<\/strong>\u00a0\u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631\u06af \u0627\u0639\u0645\u0627\u0644 \u06a9\u0631\u062f\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up94yc-3de18faa9e4f2c93486e544bcf7ea3dc\">\n#top .hr.hr-invisible.av-l0up94yc-3de18faa9e4f2c93486e544bcf7ea3dc{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up94yc-3de18faa9e4f2c93486e544bcf7ea3dc hr-invisible  avia-builder-el-58  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv7fop-c08b1e337baa6c5fc95136cd6915a690 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/456%20conditional_formatting_remove_manager.png\" alt=\"\u0645\u062f\u06cc\u0631\u06cc\u062a \u062d\u0630\u0641 \u0642\u0627\u0644\u0628 \u0646\u0628\u062f\u06cc \u0634\u0631\u0637\u06cc\" width=\"628\" height=\"300\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0up99ct-47f63128ee14df7386b387608b58fb70\">\n#top .hr.hr-invisible.av-l0up99ct-47f63128ee14df7386b387608b58fb70{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0up99ct-47f63128ee14df7386b387608b58fb70 hr-invisible  avia-builder-el-60  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0upaza1-50e0a72066a37c18f14bb81ac898f6e9 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h5><span><span class=\"goog-text-highlight\">\u0686\u0627\u0644\u0634!<\/span><\/span><\/h5>\n<ol class=\"numbered-list\">\n<li><a href=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/workfile\/21%20excel_conditionalformatting_practice.xlsx\"><span>\u06a9\u062a\u0627\u0628 \u06a9\u0627\u0631 \u062a\u0645\u0631\u06cc\u0646\u06cc<\/span><\/a><span>\u00a0\u0645\u0627 \u0631\u0627 \u0628\u0627\u0632\u00a0\u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<li><span>\u0631\u0648\u06cc \u0628\u0631\u06af\u0647\u00a0<\/span><strong><span>Challenge<\/span><\/strong><span>\u00a0worksheet \u062f\u0631 \u067e\u0627\u06cc\u06cc\u0646 \u0633\u0645\u062a \u0686\u067e \u06a9\u062a\u0627\u0628 \u06a9\u0627\u0631 \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<li><span>\u0633\u0644\u0648\u0644 \u0647\u0627\u06cc\u00a0<\/span><strong><span>B3:J17<\/span><\/strong><span> \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<li><span>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0634\u0645\u0627 \u0645\u0639\u0644\u0645 \u0647\u0633\u062a\u06cc\u062f \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0647\u0645\u0647 \u0646\u0645\u0631\u0627\u062a \u067e\u0627\u06cc\u06cc\u0646 \u062a\u0631 \u0627\u0632 \u0646\u0645\u0631\u0647 \u0642\u0628\u0648\u0644\u06cc \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f.\u00a0<\/span><strong><span>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc<\/span><\/strong><span>\u00a0\u0631\u0627 \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f\u00a0\u062a\u0627\u00a0<\/span><strong><span>\u0633\u0644\u0648\u0644 \u0647\u0627\u06cc<\/span><\/strong><span>\u00a0\u062d\u0627\u0648\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631\u00a0<\/span><strong><span>\u06a9\u0645\u062a\u0631 \u0627\u0632 70<\/span><\/strong><span>\u00a0\u0631\u0627 \u0628\u0627\u00a0<\/span><strong><span>\u067e\u0631 \u06a9\u0631\u062f\u0646 \u0642\u0631\u0645\u0632 \u0631\u0648\u0634\u0646<\/span><\/strong><span> \u0628\u0631\u062c\u0633\u062a\u0647 \u06a9\u0646\u062f\u00a0<\/span><\/li>\n<li><span>\u0627\u06a9\u0646\u0648\u0646 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u062f \u06a9\u0647 \u0646\u0645\u0631\u0627\u062a \u0686\u06af\u0648\u0646\u0647 \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.\u00a0\u062f\u0631\u00a0\u062a\u0628\u00a0<\/span><strong><span>Conditional Formatting\u060c <\/span><\/strong><strong><span>\u0645\u062c\u0645\u0648\u0639\u0647 \u0622\u06cc\u06a9\u0648\u0646\u200c\u0647\u0627 (Icon Set)<\/span><\/strong><span>\u00a0\u0628\u0647 \u0646\u0627\u0645\u00a0<\/span><strong><span>3 Symbols (Circled)<\/span><\/strong><span>\u00a0\u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.\u00a0<\/span><strong><span>\u0646\u06a9\u062a\u0647<\/span><\/strong><span>\u00a0: \u0646\u0627\u0645 \u0645\u062c\u0645\u0648\u0639\u0647 \u0622\u06cc\u06a9\u0648\u0646 \u0647\u0627 \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0645\u0627\u0648\u0633 \u0631\u0627 \u0631\u0648\u06cc \u0622\u0646 \u0647\u0627 \u0646\u06af\u0647 \u062f\u0627\u0631\u06cc\u062f \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/span><\/li>\n<li><span>\u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 \u0634\u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/span><\/li>\n<\/ol>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0upb6m7-024e050425d0206d63b482b2d5b609c1\">\n#top .hr.hr-invisible.av-l0upb6m7-024e050425d0206d63b482b2d5b609c1{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0upb6m7-024e050425d0206d63b482b2d5b609c1 hr-invisible  avia-builder-el-62  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0uv7uz0-0afd6c2ab147a48457022b275f83c0aa '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/457%20conditional_formatting_challenge.png\" alt=\"\u0646\u062a\u06cc\u062c\u0647 \u0686\u0627\u0644\u0634\" width=\"1312\" height=\"480\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l0upbbdo-8b46c13a5b8d3cdb63dba17ebdc28ec2\">\n#top .hr.hr-invisible.av-l0upbbdo-8b46c13a5b8d3cdb63dba17ebdc28ec2{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l0upbbdo-8b46c13a5b8d3cdb63dba17ebdc28ec2 hr-invisible  avia-builder-el-64  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l0upby7o-5a375caaa36ed6af8cc1cdee645408d0 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 7. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc Manage Rules\u060c <\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u0631\u0646\u06af \u0642\u0631\u0645\u0632 \u0631\u0648\u0634\u0646<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\"> \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f\u060c \u0627\u0645\u0627\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u0646\u0645\u0627\u062f \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/span><\/span><\/strong><\/p>\n<\/div><\/section>\n<div class=\"pld-like-dislike-wrap pld-template-1\">\r\n    <div class=\"pld-like-wrap  pld-common-wrap\">\r\n    <a href=\"javascript:void(0)\" class=\"pld-like-trigger pld-like-dislike-trigger  \" title=\"\u0639\u0644\u0627\u0642\u0647 \u0645\u0646\u062f\u06cc\" data-post-id=\"1332\" data-trigger-type=\"like\" data-restriction=\"cookie\" data-already-liked=\"0\">\r\n                        <i class=\"fas fa-thumbs-up\"><\/i>\r\n                <\/a>\r\n    <span class=\"pld-like-count-wrap pld-count-wrap\">0    <\/span>\r\n<\/div><div class=\"pld-dislike-wrap  pld-common-wrap\">\r\n    <a href=\"javascript:void(0)\" class=\"pld-dislike-trigger pld-like-dislike-trigger  \" title=\"\u0639\u062f\u0645 \u0639\u0644\u0627\u0642\u0647 \u0645\u0646\u062f\u06cc\" data-post-id=\"1332\" data-trigger-type=\"dislike\" data-restriction=\"cookie\" data-already-liked=\"0\">\r\n                        <i class=\"fas fa-thumbs-down\"><\/i>\r\n                <\/a>\r\n    <span class=\"pld-dislike-count-wrap pld-count-wrap\">0<\/span>\r\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>0 0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,38,34],"tags":[],"class_list":["post-1332","post","type-post","status-publish","format-standard","hentry","category-icdl","category-working-with-data","category-third-skill"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.5 (Yoast SEO v28.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc - \u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/irtecnology.ir\/?p=1332\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\" \/>\n<meta property=\"og:description\" content=\"0 0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/irtecnology.ir\/?p=1332\" \/>\n<meta property=\"og:site_name\" content=\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-19T07:58:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-19T07:58:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/442%20conditional_formatting_understanding.png\" \/>\n<meta name=\"author\" content=\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 \u062f\u0642\u06cc\u0642\u0647\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332\"},\"author\":{\"name\":\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#\\\/schema\\\/person\\\/a61ed5dd4c2b305ed9d55d3eacd6a8dd\"},\"headline\":\"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\",\"datePublished\":\"2022-03-19T07:58:20+00:00\",\"dateModified\":\"2022-03-19T07:58:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332\"},\"wordCount\":3496,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/files.irtecnology.ir\\\/files.irtecnology.ir\\\/image2\\\/442%20conditional_formatting_understanding.png\",\"articleSection\":[\"ICDL\",\"\u06a9\u0627\u0631 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627\",\"\u0645\u0647\u0627\u0631\u062a \u0633\u0648\u0645\"],\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/irtecnology.ir\\\/?p=1332#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332\",\"url\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332\",\"name\":\"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc - \u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/files.irtecnology.ir\\\/files.irtecnology.ir\\\/image2\\\/442%20conditional_formatting_understanding.png\",\"datePublished\":\"2022-03-19T07:58:20+00:00\",\"dateModified\":\"2022-03-19T07:58:23+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#\\\/schema\\\/person\\\/a61ed5dd4c2b305ed9d55d3eacd6a8dd\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/irtecnology.ir\\\/?p=1332\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332#primaryimage\",\"url\":\"https:\\\/\\\/files.irtecnology.ir\\\/files.irtecnology.ir\\\/image2\\\/442%20conditional_formatting_understanding.png\",\"contentUrl\":\"https:\\\/\\\/files.irtecnology.ir\\\/files.irtecnology.ir\\\/image2\\\/442%20conditional_formatting_understanding.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1332#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0635\u0641\u062d\u0647 \u0627\u0635\u0644\u06cc\",\"item\":\"https:\\\/\\\/irtecnology.ir\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#website\",\"url\":\"https:\\\/\\\/irtecnology.ir\\\/\",\"name\":\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\",\"description\":\"\u067e\u06cc\u0634\u0641\u0631\u062a \u0631\u0627\u0647\u0628\u0631\u062f\u06cc \u0634\u0645\u0627\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/irtecnology.ir\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fa-IR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#\\\/schema\\\/person\\\/a61ed5dd4c2b305ed9d55d3eacd6a8dd\",\"name\":\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g\",\"caption\":\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\"},\"sameAs\":[\"http:\\\/\\\/irtecnology.ir\"],\"url\":\"https:\\\/\\\/irtecnology.ir\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc - \u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/irtecnology.ir\/?p=1332","og_locale":"fa_IR","og_type":"article","og_title":"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc","og_description":"0 0","og_url":"https:\/\/irtecnology.ir\/?p=1332","og_site_name":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","article_published_time":"2022-03-19T07:58:20+00:00","article_modified_time":"2022-03-19T07:58:23+00:00","og_image":[{"url":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/442%20conditional_formatting_understanding.png","type":"","width":"","height":""}],"author":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","twitter_card":"summary_large_image","twitter_misc":{"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646":"14 \u062f\u0642\u06cc\u0642\u0647"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/irtecnology.ir\/?p=1332#article","isPartOf":{"@id":"https:\/\/irtecnology.ir\/?p=1332"},"author":{"name":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","@id":"https:\/\/irtecnology.ir\/#\/schema\/person\/a61ed5dd4c2b305ed9d55d3eacd6a8dd"},"headline":"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc","datePublished":"2022-03-19T07:58:20+00:00","dateModified":"2022-03-19T07:58:23+00:00","mainEntityOfPage":{"@id":"https:\/\/irtecnology.ir\/?p=1332"},"wordCount":3496,"commentCount":0,"image":{"@id":"https:\/\/irtecnology.ir\/?p=1332#primaryimage"},"thumbnailUrl":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/442%20conditional_formatting_understanding.png","articleSection":["ICDL","\u06a9\u0627\u0631 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627","\u0645\u0647\u0627\u0631\u062a \u0633\u0648\u0645"],"inLanguage":"fa-IR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/irtecnology.ir\/?p=1332#respond"]}]},{"@type":"WebPage","@id":"https:\/\/irtecnology.ir\/?p=1332","url":"https:\/\/irtecnology.ir\/?p=1332","name":"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc - \u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","isPartOf":{"@id":"https:\/\/irtecnology.ir\/#website"},"primaryImageOfPage":{"@id":"https:\/\/irtecnology.ir\/?p=1332#primaryimage"},"image":{"@id":"https:\/\/irtecnology.ir\/?p=1332#primaryimage"},"thumbnailUrl":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/442%20conditional_formatting_understanding.png","datePublished":"2022-03-19T07:58:20+00:00","dateModified":"2022-03-19T07:58:23+00:00","author":{"@id":"https:\/\/irtecnology.ir\/#\/schema\/person\/a61ed5dd4c2b305ed9d55d3eacd6a8dd"},"breadcrumb":{"@id":"https:\/\/irtecnology.ir\/?p=1332#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/irtecnology.ir\/?p=1332"]}]},{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/irtecnology.ir\/?p=1332#primaryimage","url":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/442%20conditional_formatting_understanding.png","contentUrl":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/442%20conditional_formatting_understanding.png"},{"@type":"BreadcrumbList","@id":"https:\/\/irtecnology.ir\/?p=1332#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0635\u0641\u062d\u0647 \u0627\u0635\u0644\u06cc","item":"https:\/\/irtecnology.ir\/"},{"@type":"ListItem","position":2,"name":"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc"}]},{"@type":"WebSite","@id":"https:\/\/irtecnology.ir\/#website","url":"https:\/\/irtecnology.ir\/","name":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","description":"\u067e\u06cc\u0634\u0641\u0631\u062a \u0631\u0627\u0647\u0628\u0631\u062f\u06cc \u0634\u0645\u0627","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/irtecnology.ir\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fa-IR"},{"@type":"Person","@id":"https:\/\/irtecnology.ir\/#\/schema\/person\/a61ed5dd4c2b305ed9d55d3eacd6a8dd","name":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/secure.gravatar.com\/avatar\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g","caption":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646"},"sameAs":["http:\/\/irtecnology.ir"],"url":"https:\/\/irtecnology.ir\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/posts\/1332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1332"}],"version-history":[{"count":2,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/posts\/1332\/revisions"}],"predecessor-version":[{"id":1334,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/posts\/1332\/revisions\/1334"}],"wp:attachment":[{"href":"https:\/\/irtecnology.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}