• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting

J

jagdishrmane

New Member
Hi All,


I have a very simple question in conditional formatting.


I want font color of city "Pune" to be Red. When I try that text color for the entire cell changes to Red.


Is there any way that by we can change the color of specific text using conditional formatting.


eg.

"Pune" City

City "Pune"

"Pune" Corporation


Text Color of Pune should be red and not city should remain as it is.


Any clue / pointers are really appreciated.


Regards,

Jagdish Mane
 
Jagdish


Firstly, Welcome to the Chandoo.org Forums


There isn't a way to use conditional formatting to highlight individual words as you suggested


It could be done using VBA if the cells only contain words and not formulas
 
You must log in or register to reply here.
Back
Top