I’ve got 2 similar questions.
- is there an easier way to run the same formatting rule for different columns without just repeating the rule. For example i want a simple “If cell is non-empty colour green” and i want the same thing to apply in about 15 different columns.
- I want to have a partial portion of a row highlight a colour when one cell is non-empty. At the minute i only have the option to fill entire row which is not what im after.
Thanks in advance