In my spreadsheet I have 12 sheets (jan,feb,march, ect) I used to be able to edit all 12 of those sheets at once by using ctrl + clicking each sheet. So for example if i wanted to add “2012” in A1 in all 12 sheets i would use ctrl to select all 12 sheets, then i would edit A1 with “2012”, then press enter. After i pressed enter it would change ALL 12 sheets in cell A1. I want to do this with “Conditional Formatting”
I cant seem to make it work with the latest version. Any suggestions? Thanks