Hi Again
I have a spreadsheet and on that spreadsheet I would like to make it easier to insert ticks and crosses. What I would like to happen is that if i type the number '1' in Column 'C' (e.g. 'C3') then I would like that cell to populate with a tick (aka cell 'O44') or if I enter a '0' i would like the current cell to populate with a cross (aka cell 'O43').
I would also like the same thing to happen if i type a '1' or '0' in Columns D,J,K.
Thanks for any help
Rhiannon
Reward Scratchies Tracking Spreadsheet Example.xls
Bookmarks