LinkBack URL
About LinkBacks
Hey Guys,
I have a Sheet with a table and many Numbers, on some Cells there is a Number with a "B E" before and I want to change the Background Color of those Cells where a "B E" is standing before.
How can I code that?
Thanks Ahead
Hey Guys,
I have a Sheet with a table and many Numbers, on some Cells there is a Number with a "B E" before and I want to change the Background Color of those Cells where a "B E" is standing before.
How can I code that?
Thanks Ahead
No need to go for VBA, just a Conditional Formatting will do that for you
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
yeah I know but to do it with VBA would be better because I did anything on it now and later someone just hast to run the macro and have the results,
is it possible on macro?
If I do this nothing happens. Color remains the same
Please Login or Register to view this content.
Thats not the whole Code just the piece where I tried to change the color.
Thanks :D
Last edited by Jangorage; 09-22-2014 at 03:50 AM.
Try this...
Please Login or Register to view this content.
Awsome, it worked instantly, damn you guys are good, always the right answer, Thank you very much :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks