Excel formula to get cell color [duplicate]

by

As commented, just in case the link I posted there broke, try this:

Add a Name(any valid name) in Excel’s Name Manager under Formula tab in the Ribbon.
Then assign a formula using GET.CELL function.

=GET.CELL(63,INDIRECT("rc",FALSE))

63 stands for backcolor.
Let’s say we name it Background so in any cell with color type:

=Background

Result:
enter image description here

Notice that Cells A2, A3 and A4 returns 3, 4, and 5 respectively which equates to the cells background color index. HTH.
BTW, here’s a link on Excel’s Color Index

More Related Contents:

  1. How to turn a string formula into a “real” formula?
  2. Last non-empty cell in a column
  3. Rounding in MS Access
  4. Fill non-contiguous blank cells with the value from the cell above the first blank
  5. Excel Reference To Current Cell
  6. How to extract text within a string of text
  7. Get parent folder path from file path using cell formula
  8. How to copy Outlook mail message into excel using VBA or Macros
  9. For Loop not fully cycling in excel VBA [duplicate]
  10. How to loop through Excel files and load them into a database using SSIS package?
  11. Unique Random Numbers using VBA
  12. Save each sheet in a workbook to separate CSV files
  13. Export each sheet to a separate csv file
  14. How to construct Dataframe from a Excel (xls,xlsx) file in Scala Spark?
  15. Detect if range is empty
  16. Checking if a worksheet-based checkbox is checked
  17. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  18. Round function in Excel, worksheet function vs VBA
  19. Uncheck all checkboxes across entire workbook via CommandButton
  20. VBA workbooks.Close without being prompted to if the user wants to save?
  21. Excel: Use a cell value as a parameter for a SQL query
  22. VBA equivalent to Excel’s mod function
  23. Excel macro – paste only non empty cells from one sheet to another
  24. Convert from US to UK format
  25. Pointers needed for speeding up nested loop macro in VBA
  26. Comparing two columns on sheet1 to two other columns on sheet2 and returning another column in sheet 2.
  27. ‘1004’: “The sort reference is not valid.”
  28. Create hyperlink to another sheet
  29. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  30. How to highlight selected text within excel

Leave a Comment