I would like to apply conditional formatting to selected cells applying the following conditional formatting:
Interior.Color = RGB (243, 17,19)
Font.Color = RGB (255, 255, 255)
The conditional formatting is based on a formula:
The selection is always a vertical selection of cells and in the above example the selected cells start at A2. But of course the selection could also start a B5 and extend to B400 or C2 and extend to C1200
Is there a way to run a macro to apply the above conditional formatting to any vertical selection I wish to make.
Help is much appreciated. Thank you very much in advance.