Hello! I am trying to update rules between multiple rows. For example, I have rows 1, 2, and 3. The formatting will remain the same between each row, but the rule will change based on the spreadsheet. For example, with row 1, when cell C3 on Sheet 2 is equal to the number 1, I want a blue background to appear.
I want this same rule/formatting to apply to row 2 and 3, but to pull the number from sheet 3 and 4, respectively.
When I click manage rules and simply try to change the formula, whether by typing in the sheet name or by retyping in the formula, nothing happens.
Is there a way to keep formatting across cells the same, just change the sheet it is pulled from, without having to clear the rules for each row and restart over?
