I have a file having a column with some datas.But,in a same column there is some common field,appear so many times.Can it be possible to give a font colour to it?
For more clarification,please refer the attach file.
Regards
I have a file having a column with some datas.But,in a same column there is some common field,appear so many times.Can it be possible to give a font colour to it?
For more clarification,please refer the attach file.
Regards
Regards
Pradeep Kumar Gupta
Gurgaon ( INDIA )
Hi for this example you can use such code (select the range and run this)
but this is not very much flexible.
more flexible versionPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by tom1977; 03-22-2012 at 05:52 AM.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Is it not possible through an excel formula?
The only other way is using conditional formatting.
@tom1977 you are right I didn't realise he only wanted part of a cell changed.Hi darknatiion144 do you know how to obtain this on the part of cell's text? Please let me know because my present knowledge tells me that this impossible.
Use Conditional Formatting Tool from the Home Tab in Excel 2010...
Or use Vlookup
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks