How to use a formula to determine the Cell Style?
JP,
I hate to abuse this site, but I think you would be the best one to ask
since you created the function. I'm trying to get a count of various cells
that contain particular styles. I tried this:
"=COUNTIF(B4:P53,Cellstyle(Accent1))". I believe this is closer to correct
(and I tried it as well): =COUNTIF(B4:P53,Cellstyle("Accent1")). They are
returning 0 as the count. I'm not sure why though. Any ideas?
Thanks again,
Gerard
"JP" wrote:
I wrote a simple function to return the style of a given cell.
Function Cellstyle(inp As Range) As String
Cellstyle = inp.Style
End Function
Assume you have some data in cell A1. In B1 enter =Cellstyle(A1).
HTH,
JP
On Nov 13, 4:13 pm, Gerard wrote:
I'm trying to use a formula to determine the Cell (custom) Style? I believe
that once I have this formula figured out I will be able to use it to "Count"
the number of cells with a particular Style and display this. Any ideas?
Thanks,
Gerard
|