{"id":542,"date":"2016-11-07T08:00:37","date_gmt":"2016-11-07T08:00:37","guid":{"rendered":"http:\/\/99excel.com\/home\/?p=542"},"modified":"2021-05-14T16:08:30","modified_gmt":"2021-05-14T16:08:30","slug":"how-to-return-background-color-of-cell-vba-code-resolved","status":"publish","type":"post","link":"https:\/\/99excel.com\/home\/how-to-return-background-color-of-cell-vba-code-resolved\/","title":{"rendered":"How to return background color of cell – Vba Code resolved"},"content":{"rendered":"

Copy & paste below VBA code in your Module & use function “=CellColorIndex(A2)<\/span>” in sheet.<\/p>\n

 <\/p>\n

Function CellColorIndex(InRange As Range, Optional OfText As Boolean = False) As Integer<\/span>
\n   ‘This Code created by Akumar, www.99excel.com<\/span>
\n   Application.Volatile True<\/span>
\n   If OfText = True Then<\/span>
\n   CellColorIndex = InRange(1, 1).Font.ColorIndex<\/span>
\n   Else<\/span>
\n   CellColorIndex = InRange(1, 1).Interior.ColorIndex<\/span>
\n   End If<\/span>
\nEnd Function<\/span><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Copy & paste below VBA code in your Module & use function “=CellColorIndex(A2)” in sheet.   Function CellColorIndex(InRange As Range, Optional OfText As Boolean = False) As Integer    ‘This Code created by Akumar, www.99excel.com    Application.Volatile True    If OfText = True Then    CellColorIndex = InRange(1, 1).Font.ColorIndex    Else    CellColorIndex = InRange(1, 1).Interior.ColorIndex   … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-542","post","type-post","status-publish","format-standard","hentry"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=542"}],"version-history":[{"count":2,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/542\/revisions"}],"predecessor-version":[{"id":876,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/542\/revisions\/876"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/categories?post=542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/tags?post=542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}