Hi Community,
I am trying to format the cells in excel based off the “X” in column ‘I’ + some input ‘D’ in excel. While I am able to get the row or range of cells I am struggling to format. For example, highlighted in orange I’d like to add a black background and change text to white.
As a test created a list of some ranges (image below) but doesn’t seem I could do it this way? Seems to work with a single range only?
Is there a better way to do this? Search Value Get Row?
Thanks in advance for your thoughts,
Dan