Share via

In excel, conditional formatting

Anonymous
2015-03-23T21:34:00+00:00

In excel, I have a column of numbers that needs to be custom formatted to add the text "Amicus" # - in the Blue font color in front of the code number, but how & where is that located on my sheet?

I can not find it in my college book.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Ashish Mathur 101.9K Reputation points Volunteer Moderator
2015-03-24T02:40:59+00:00

Hi,

  1. Press Ctrl+1 on cell A2
  2. Go to Numbers > Custom > Type
  3. Type this in the box there

"Amicus #"General

You can now colour the cell as Blue.

Hope this helps.

Was this answer helpful?

4 people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-03-23T23:43:03+00:00

    DK

    Then why are you posting thins in outlook.com which is browser based?  I am moving this to Office 2013 as that is where this should be posted

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-03-23T22:26:48+00:00

    no, that answer was not helpful @ all....

    I have Excel 2013 on my computer, it never needs a browser.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-03-23T22:03:04+00:00

    I suspect this is related to MS Office Outlook and not outlook.com (browser based) where you posted this.  If I am correct please repost this in the MS Office category for the version you have by using the category tab at the top of the page

    Was this answer helpful?

    0 comments