How to chang text color automaticaly in excel

Closed
sanchit bedi - Jan 3, 2011 at 03:24 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 05:05 PM
Hello,

I want to chnge the text color if the value of other relative cell is changed.

For eg. I have cell range from B11 to XAV11, if any value of any cell is changed between this range then the text color of corresponding cell of row3 of same column should change automatically.

Can any on help me on this.

I have excel 2007 installed on my computer.

Thanks

Sanchit Bedi

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 05:05 PM
you can do that with conditional format
0