color table.jpg
Need formula or macro to read hex color (RGB) and fill cell with background color.
color table.jpg
Need formula or macro to read hex color (RGB) and fill cell with background color.
The formula for that cell would be
or![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, I should have mentioned thatSorry
Ok, what's a UDF?
![]()
Please Login or Register to view this content.
What is a UDF ?
http://www.myonlinetraininghub.com/c...ction-in-excel
Last edited by Logit; 03-08-2017 at 10:06 PM.
Here is an update to the previously attached file :
![]()
Please Login or Register to view this content.
(UDF = User Defined Function.)
Thank you very much for the info. I'm not up to speed on programming Visual Basic, though I have done a few short macros.
Last edited by tcebob; 03-08-2017 at 10:36 PM.
Let me know if I can assist.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks