1 min readfrom 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!

submitted by /u/THE_GREAT_PICKLE
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com