Hi All,
I am presently working on an excel worksheet which has numerous rows. I need to see each cell in column B and if i find the word "Red" in the cell, i need to change the color of the entire row to Red.
I tried to use conditional formatting for the purpose, however, it didnt work. I guess, conditional formatting works only when the entire cell value is "Red". In my case, the cell value may be something like "I Like Red, Blue and Green Color", or it can also be "Red is my favorite color".
Please can someone help me design a macro for the purpose.
Thanks,
Lonely
I am presently working on an excel worksheet which has numerous rows. I need to see each cell in column B and if i find the word "Red" in the cell, i need to change the color of the entire row to Red.
I tried to use conditional formatting for the purpose, however, it didnt work. I guess, conditional formatting works only when the entire cell value is "Red". In my case, the cell value may be something like "I Like Red, Blue and Green Color", or it can also be "Red is my favorite color".
Please can someone help me design a macro for the purpose.
Thanks,
Lonely