{"id":7169,"date":"2021-11-23T10:07:00","date_gmt":"2021-11-23T10:07:00","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=7169"},"modified":"2021-11-23T10:08:27","modified_gmt":"2021-11-23T10:08:27","slug":"excel-formulas-to-show-clashes-how-to-set-up-aspreadsheet","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-formulas-to-show-clashes-how-to-set-up-aspreadsheet\/18655.html","title":{"rendered":"Excel Formulas To Show Clashes &#8211; How To Set Up Aspreadsheet"},"content":{"rendered":"<p>I need to create a spreadsheet which will show clashes, i am an administrator timetabling and i need a sheet which will pick up room\/student clashes. I am using a sheet created by another locality which has been set up to highlight the rows in yellow which are clashing and it flashes and states Clash in a column at the end. If i click in &#8216;show formula&#8217; and then click in the cell at the end with the title Clash? i get the following formula =IF(O2&gt;0,&#8221;Clash * &#8220;&amp;O2;,&#8221;&#8221;), any help with setting up my own sheet would be much appreciated! \ud83d\ude42<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":23},"question-category":[53],"question_tags":[],"class_list":["post-7169","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/7169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=7169"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=7169"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=7169"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=7169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}