How to chang text color automaticaly in excel

Closed
sanchit bedi - Jan 3, 2011 at 03:24 AM
rizvisa1
Posts
4479
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 reply

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