Forum Discussion

Ronald_Hoerner's avatar
Ronald_Hoerner
Copper Contributor
Jan 29, 2023
Solved

cell format info in formulas

I wrote a small routine to count the number of cell in a range (calendar_ronald)  that match the color of a cell (cell_color).   Sub CountCellsByColor() Dim calendar_ronald As Range Dim cell_colo...
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Jan 29, 2023
    No. Function can't work with color.
Harun24HR's avatar
Harun24HR
Bronze Contributor
Jan 29, 2023

Ronald_Hoerner To get count result in cell replace below line-

MsgBox "The number of cells in the given area with the specified color is: " & color_count

With

Range("F1") = color_count
  • Ronald_Hoerner's avatar
    Ronald_Hoerner
    Copper Contributor
    Jan 29, 2023

    Thanks Harun24HR 

     

    Is it also possible to do this with a function instead of a macro?

    • Harun24HR's avatar
      Harun24HR
      Bronze Contributor
      Jan 29, 2023
      No. Function can't work with color.

Resources