Hi, I have a large dataset and am trying to find a quick way to format certain cells without setting up hundreds of conditional formatting rules.
Where a cell = "A", I would like the cell above to highlight in Yellow. Where a cell = "C", I would like the cell above to highlight in Green.
Please can someone advise the best way to accomplish this, a macro or conditional formatting. Not had much luck so far.
Appreciate your guidance. Thanks.
Where a cell = "A", I would like the cell above to highlight in Yellow. Where a cell = "C", I would like the cell above to highlight in Green.
Please can someone advise the best way to accomplish this, a macro or conditional formatting. Not had much luck so far.
Appreciate your guidance. Thanks.