I've a list of numbers I go through (testing them). My test will determine one of 2 things: that a number is to be 'rejected', so I count it out by selecting the cell and clicking a macro that recolors it to a blue background with blue font. Or my test determines that a number is to be 'kept' and I mark that by selecting that cell and using another macro that changes the cell's colors differently (yellow background with brown font). So it's sort of visual. But I'd like a formula to count up the total number of blue-on blues I have, as well as the yellows-on-brown. Are their values we can use in formulas to denote specific colours in cells? Something the equivalent of: countif(range of number values, colour=yellow)...if you follow me. Thanks for any help.
Bookmarks