Hi I have been trying to figure something out in Excel but have been getting nowhere. My problem is that I need cell J5 to highlight and display a message if all the cells from D5 - I5 are highlighted. I would be grateful if someone could could help me out with this.
Thanks
Yes, you need to check out conditional formatting rules. I hope this helps - http://www.contextures.com/xlCondFormat03.html
Also, google "MrExcel" for additional resources on this subject. There is a way.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.