I have a database of names in one column in excel 2010 and over time I have coloured the text of some of the names green to show that they have been added to a new online database. I want to be able to count how many of the names have been coloured so I can see if it matches with the total number already added on to the online database. I have over 800 entries so I don’t want to have to manually count them unless I find I have missed any. Conditional Formatting is greyed out (it is a Shared document so that might be why).
Can anyone help me in creating an IF (text is a certain colour) THEN 1, 0… or any others ways I can find the total in that colour. I only have two text colours in my spread sheet, black and light green.
Thanks
Example of Table.JPG
Bookmarks