Change text color

Hi,

Have you looked at Conditional Formatting which I suspect will give you exactly what you want.

Regards

Hi,
You can click on any cell and change the color of the text by using the toolbar. Also see if you can right click on the cell and get an option to change the font color from the dropdown.

You haven't given us any rules for changing the color of font characters.

Hi Richard and Marvin,

Thanks a lot for your reply!!

I have been tried out conditional formatting; but that is not help.
I am attaching a sample row of the spreadsheet.
03/15 - RGE approved by RGE and advised to create DOU instead of Detail design
03/16 - Raghabendra needs to follow up wih RM

After my next meeting;i have to update the comment mentioned on 03/16 with red to blue andd new updates in red.

Please help me now.This activityis eating a lot of time of mine.

Thanks!
Raghabendra das

Here is the site you should read
http://www.mvps.org/dmcritchie/excel/condfmt.htm
I hope the date in your row is in a cell by its self. If it is then the above link should do it for you.

Hi,

But what is the trigger? You say after your next meeting but how is Excel to know what that means. Is that a date? You will need to make an entry in some cell in order to tell Excel that you have had a meeting.

Then once you've made an entry, how does the text you show relate to that entry. For instance is the 03/16 significant. Is this shorthand for a date perhaps?

You need to work out the rules and then you will have the ability to use conditional formatting.

Regards