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.

Please contact us here

We usually reply in a few hours. (And yes, we are real people!).

Our working hours:
Pacific Time (PT) 11:00 PM (previous day) – 2:00 PM
Central European Time (CET) 08:00 - 23:00
Eastern Time (ET) 2:00 AM – 5:00 PM
Central Time (CT) 1:00 AM – 4:00 PM
Pacific Time (PT) 11:00 PM (previous day) – 2:00 PM
Australian Eastern Daylight Time (AEDT) 6:00 PM – 9:00 AM (next day)
If you want to attach files (e.g. screenshots or log files), it will be possible right after you send this form and we automatically create a support ticket for you.

Thank you for contacting us!

We'll get back to you shortly. You should receive a confirmation email within a few minutes. If it doesn't arrive, please resend your message and make sure your email address is entered correctly.