AblebitsGetCellColor function

The AblebitsGetCellColor function returns the color code of the background color of the selected cell.

For example:

=AblebitsGetCellColor(N22) Returns the color code of the background color of the N22 cell.

Note. Formulas created with this function will work only on machines with installed Ultimate Suite for Excel. If the workbook is opened on another computer where Ultimate Suite is not installed, the result will be lost.
Tip. You can find the complete list of custom functions on the Ablebits functions for Excel page.

Syntax

AblebitsGetCellColor(reference)

The AblebitsGetCellColor function syntax has the following argument:

  • reference
    Required. The cell reference with background color to return, e.g. B2.

Remarks

  • The function does not work for conditionally formatted cells and for ranges formatted as tables with colored alternate rows or columns.

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Ablebits.com on Facebook Ablebits Youtube channel
Copyright © 2003 - 2021 4Bits Ltd. All rights reserved.   Privacy policy   Terms of use   Contact us
Microsoft and the Office logos are trademarks or registered trademarks of Microsoft Corporation. Google Chrome is a trademark of Google LLC.