I want to highlight a cell in column A with the same color as any cell in that row if it is colored, to visually flag important data.
Hoping you can help me! Everyone at my office is a huge novice with Excel - I understand the basics but am not terribly great myself. We need one (hopefully) simple thing. Essentially, we have a dataset that we want to flag column A with a highlighted color if anything in that row is a color. Column A will always contain one of 5 words -- I've already done that with data validation. But what we want is, for instance, if I highlight cell H7 in yellow, it would then highlight A7 with the same color. I tried playing around with conditional formatting but I wasn't able to get it quite right. Thanks in advance for any assistance you can give!