CODEWITHSUNDEEP
excelms-office
Alpesh Patoliya
Alpesh Patoliya

Reputation: 263

How to check excel cell style using formula?

I had one problem to how to make separate column which is bold among 4. Let me explain in detail I'm using excel win 2010. i have questions with 4 multiple answer i want to make separate column with true answer. true answer is bold. In 4 answers one of is bold so checking all 4 which is bold one copy to true answer column check attached screenshot.enter image description here

Upvotes: 0

Views: 5429

Answers (1)

Jerry
Jerry

Reputation: 71548

Here's a solution by filtering:

  1. Apply a filter on the columns containing the answers

  2. Select the columns containing the answers and do a replace (or hit Ctrl+H)

  3. Hit the Options >> button and click on Format for the Find and pick Font > Bold

  4. For the replace, do the same thing but pick Fill > Yellow (or any other colour you like). You should get something like this now:

    enter image description here

  5. Click Replace All button so that all the bold answers are now highlighted.

  6. Filter the first column of answers by colour so that you have only the highlighted cells. Assuming that the first answer A is in cell B2, put the formula =B2 in the last column (i.e. 4 columns before and same row) and fill down the formula.

  7. Repeat step 6 for all the other answers making sure you are taking the right column in the formula.

  8. Remove the colours from the answer columns.

For A, you should have something like:

enter image description here

For B...

enter image description here

etc.

At the end, you should have something like this:

enter image description here

I have added column G to show the different formulas.

Upvotes: 1

Related Questions