Hi guys,
On my workbook in Sheet3 I have an IF formula that once various data is processed so that Cell F30 shows Yes or No and turns Green or Red via Conditional Formatting.
On UserForm1 I have a Textbox that displays Yes or No, based on the value shown in F30. Is there a way to copy the colour from Cell F30 into the TextBox, even though it is coloured via CF?
Many thanks,
Chris
Not easily I think...
https://excelfox.com/forum/showthrea...atting-or-not)
Please Login or Register to view this content.
Last edited by sintek; 06-18-2020 at 12:22 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Not sure if you have DisplayFormat, but if so, how aboutPlease Login or Register to view this content.
@ fluff... that didnt work for me strange enough...
Not sure when DisplayFormat appeared, I suspect it was either 2007 or 2010, but pretty sure I used it with 2013.
Did you get an error message?
@ Fluff13
Worked on other PC 2013,
2007 no change, 2010 turned black ... should have been red...
anyway thanks ...
It was introduced with 2010 (so should have caused an error in 2007).
Remember what the dormouse said
Feed your head
Perfect, thanks Sintek.
No...Fluff13 posted perfect solution...If post 2007 version...Perfect, thanks Sintek.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks