Can someone help me determine if this is doable and how?
If Column B is Highlighted Yellow place an "x" in column A.
Can someone help me determine if this is doable and how?
If Column B is Highlighted Yellow place an "x" in column A.
Do you mean a cell like B3 is yellow then put ax x in A3?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
You will need VBA to check cell colours.
What is condition that decides the cell colour? You could then use this check for filling A with "x"
Hi and welcome to the forum.
Not with a regular Excel function. (There might be an old Excel4 'GET' type "macro function" hanging around which I'll check later). But in the absence of a regular function then you can easily do it with VBA. e.g.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thanks for your assistance. I appreciate the Welcome!
Unfortunately, I am a complete Divvy when it comes to VBA and how to add. I have the Developer Ribbon... next?
Yes, that's it. except I need to review about 3000 rows.
In Richard's code, just change the "1 to 10" to "1 to 3000"Yes, that's it. except I need to review about 3000 rows.
Change A1 to whatever your first cell is.
To insert the code, ALT + F11 to open VBA Editor
Insert>Module
Paste in the code. Close the editor
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks All! My world in back in order...
Great!... Glad to have assisted and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks