1
Campus Freelance Creative Playbook
Aaron Greville edited this page 7 days ago
=ARRAYFORMULA( IFERROR( QUERY( IMPORTRANGE("https://drive.google.com/file/d/1abc..","2024-05-chase.csv!A1:F999"), "select Col1,Col2,Col3,Col4,Col5*-1,Col6 where Col1 is not null Freeze the third row and column A, then protect the span B3:E3 (lodging, groceries, commute, fun) so no one tampers with the headers by mistake. Grab F3:F32, navigate to Format >Conditional formatting, choose "Custom formula" and enter =F3>E3