Hi,
Is it possible to 'reset' the color scale conditional format each time it detects a new dataset (after each empty row in this example). Currently I am stuck with the color scale as applied to the entire column, which is not ideal. In the example below what I have left (applied to entire column), what I want is to the right (applied separately between empty rows). Thanks
Is it possible to 'reset' the color scale conditional format each time it detects a new dataset (after each empty row in this example). Currently I am stuck with the color scale as applied to the entire column, which is not ideal. In the example below what I have left (applied to entire column), what I want is to the right (applied separately between empty rows). Thanks