Forum Discussion

topcat999's avatar
topcat999
Copper Contributor
Apr 26, 2019
Solved

Counting text of a specific colour & font

I am trying to establish a COUNTIF formula that will accurately count the number of identical single text characters in a specific colour in a range of cells in a row that contains the same text char...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 26, 2019

    topcat999 ,

     

    Afraid that's if only with VBA, not with formula. Formulas work with cell values, not with their attributes like colors.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 26, 2019

topcat999 ,

 

Afraid that's if only with VBA, not with formula. Formulas work with cell values, not with their attributes like colors.

topcat999's avatar
topcat999
Copper Contributor
Apr 26, 2019

Thank you for that, SergeiBaklan. Your help and advice greatly appreciated. 

Resources