•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting highlighted cells
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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com