1# Conditional formatting and data validation: a task list whose done2# tasks are struck through in green, whose hours are shaded on a color3# scale, and whose total turns magenta past 100. Space checks a box,4# Alt+Down (here from the palette, as VHS can't type it) opens an5# owner's dropdown, a value the rule rejects is refused6# with Sheets' words, and Format > Conditional formatting lists the rules.7Output out/rules.gif8Source lib/setup.tape9Set Theme "rose-pine-dawn"1011Hide12Type "../bin/012 data/tasks.012" Enter13Sleep 2s14Show1516Sleep 1s17Down@300ms 2 Right@300ms 318Sleep 600ms19Space20Sleep 1.5s21Left@300ms 2 Down@300ms 222Sleep 600ms23Ctrl+K24Type@100ms "open dropdown"25Sleep 500ms26Enter27Sleep 1s28Type@150ms "bo"29Sleep 800ms30Screenshot out/stills/rules-dropdown.png31Enter32Sleep 1s33Right Up@300ms 234Type "90" Enter35Sleep 1.5s36Screenshot out/stills/rules-reject.png37Escape38Sleep 500ms39Type "70" Enter40Sleep 2s41Screenshot out/stills/rules-sheet.png42Sleep 500ms43Ctrl+K44Type@100ms "conditional formatting"45Sleep 600ms46Enter47Sleep 1s48Down@500ms 249Sleep 1.5s50Screenshot out/stills/rules-panel.png51Escape52Sleep 1s