I want to use conditional formatting to change the cell color in column B for the cell value in column H. I will need multiple rules because there are multiple colors. Can this be done? See attached. My whole sheet has about 100 rows in various columns.
Bookmarks