If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Conditional formatting

shlen · 2009-06-25 12:45:00

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

25-06-2009 1:45pm

#1
shlen

Closed Accounts Posts: 22 ✭

Join Date: January 2009

Posts: 9
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:

excel

conditional formatting

0

Comments

#2 25-06-2009 2:14pm

FSL

Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭

Join Date: February 2006

Posts: 1419

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.

0
#3 25-06-2009 2:30pm

Antar Bolaeisk

Registered Users, Registered Users 2 Posts: 3,091 ✭✭✭

Join Date: May 2009

Posts: 2997

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:

into this:

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.

0