Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Conditional formatting

  • 25-06-2009 01:45PM
    #1
    shlen
    Closed Accounts Posts: 22 ✭


    Have a spread sheet with over 10,000 enteries want to format ones that just have "_something" at the end with red colour font.Ctrl F and "_something" will find all the enteries i wan to format, so how do i format it text in conditional formatting???surely its something simple....Using 2003 btw
    Tagged:


Comments

  • #2
    FSL
    Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭FSL


    Look up conditional formatting in Excel Help. you can choose a range of cells and apply a format and a condition. The format is applied if the condition is true.


  • #3
    Antar Bolaeisk
    Registered Users, Registered Users 2 Posts: 3,091 ✭✭✭Antar Bolaeisk


    Not sure how to do it with the conditional formatting but a macro, as demonstrated in the sample file, should work for you.

    _something.xls

    Turning this:

    _something1.png

    into this:

    _something2.png

    Basically it'll work down through column A applying the formatting where appropriate until it reaches an empty cell. Let me know if you have a problem with it or want something explained.


Advertisement