format cells having text
Hi frends,
I have a question.I have put a lot of charts in the worksheet which are specific to each person. I put the person's name followed by his/her charts.then I put the next person's name in the adjacent cell followed by his charts. So the persons names are not in a single column or row. I would like to format the cells having the text(persons name) so that they appear prominent. How do I format the cells with a color and bold text.At present I am formatting each cell having the name and then applying format painter to the next cell containing text. But it is taking a lot of time. since I have a lot of entries. On this worksheet apart from the names, I have not entered any text or number into the cells. Is it possible to write a formula so that whenever I enter any text in this worksheet cells, it takes the required format. thanking you friends in advance |
Select the entire sheet (click the empty grey box just to the left of the
ColA heading) Use Format/Conditional Formatting Change "Cell Value Is" to "Formula Is" In the formula box put =IsText(A1) Apply whatever formatting you want Hit OK Enter some text to see how it works. Rgds, ScottO "steve" wrote in message ... | Hi frends, | I have a question.I have put a lot of charts in the worksheet which are | specific to each person. I put the person's name followed by his/her | charts.then I put the next person's name in the adjacent cell followed by his | charts. So the persons names are not in a single column or row. I would like | to format the cells having the text(persons name) so that they appear | prominent. How do I format the cells with a color and bold text.At present I | am formatting each cell having the name and then applying format painter to | the next cell containing text. But it is taking a lot of time. since I have | a lot of entries. On this worksheet apart from the names, I have not entered | any text or number into the cells. Is it possible to write a formula so that | whenever I enter any text in this worksheet cells, it takes the required | format. | thanking you friends in advance |
Thank you very much ScottO !,it did work.Thanks for you help. |
All times are GMT +1. The time now is 09:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com