Hi all,
I would like to populate the text in cell B1 based on the color of A1. Essentially, If A1 is red, then B1 would say Missed. If A2 is green, B2 would say Shipped.
PS
I've had success populating B1 with the text of A1 if A1 is red which seems a bit more complicated than this. I am also using multiple sheets so simple cond. formatting or a cell color function won't necessarily work.
Thanks!
Hello cp41,
Embarking on a route of coding for answers based on cell colors, opens you wide open for BIG problems further down the road.
Is there absolutely no other way you could approach your issue?
With Thousands of different shades of color, you will very soon find youself very hard put to Code accordingly!
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks