conditional formatting excel 2010 how to change color if a cell is bold
Posted on 2014-03-19
I am going through a table of data comparing cells to a paper print out to make sure numbers match. Once I check a cell, I bold it.
I want to then sort out / remove rows that have bolded numbers so I can see what's not bold / still have to check.
I was thinking conditional formatting to highlight a row if the certain cell in that row is bold, then manually sort the rows by color (seeing a background color is easier than looking for the bold in a cell).
Any thoughts on how to write a conditional formatting equation based on a cell already being bold?
And / or a way to check a cell, flag it easily and then sort the rows by the that flag method