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 character in a different colour. Is this possible, please? If so I would be very grateful for help with this request. Many thanks.
Thank you @Sergei Baklan . I am not that proficient with Excel, unfortunately, but when I accessed the Help function on using COUNTIF it suggested that "Excel supports User-Defined Functions using VBA operations on cells based on background or font colour."
Is it possible you could guide or demonstrate this for me, please?