[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 629
  • Last Modified:

conditional formatting excel 2010 how to change color if a cell is bold

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
0
BeGentleWithMe-INeedHelp
Asked:
BeGentleWithMe-INeedHelp
2 Solutions
 
nutschCommented:
Bold doesn't get picked up by the conditional formatting, however, if you put the attached code in a module of your workbook, you can call it in your worksheet as follows and use that as a sort / filter column

=IsBold(A1)

Function isBold(rg As Range)

isBold = rg.Font.Bold
    
End Function

Open in new window

0
 
Naresh PatelTraderCommented:
Or You can See This Link.I had asked same question. what I did is - Used IF Formula returning if formula to Yes or Noo (If Text is bold or not) then Sort that in A To Z. Delete which is bold.

This only for answer sack, don't allot me any point as this is not my solution.

See Attached

Thanks
format-test1.xlsm
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now