I have a sheet that I am working with that I would like to find all cells that match a specific font color. I’ve been trying to figure this out myself but I am not having any luck so far. Can someone help me find the right way to do this?
If you used cell styles for attribution then enable Cell styles in the Find&Replace dialog’s Other options.
If you did not use cell styles but hard manual formatting instead then there is no way (other than writing a macro that iterates over cells and gathers attributes).
Ok thanks! I’ve been doing formatting by hand for what I am working on. i did not really know much about Calc except for the basic stuff I learned from Excel classes in college and did not think to check for anything that might help me format my spreadsheet quicker than doing it by hand.