get a colored text in one cell to appear the same way in others
I would like to have a cell that says "great" and is colored purple to
appear the same way whenever I type the word "great" |
One way
Formatconditional formatformula is=a1="great"<select formating Adjust cell location as required HTH "anton" wrote: I would like to have a cell that says "great" and is colored purple to appear the same way whenever I type the word "great" |
Use conditional formatting, select the range of cells wheer you want "great" to be coloured purple, then from the format menu select conditional formatting, leave condition 1 as "Cell value is" from the next drop down select equal to, in the third box type great and then click on the format button and select the format you want -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=390970 |
Perfect! Thank you
"Paul Sheppard" wrote: Use conditional formatting, select the range of cells wheer you want "great" to be coloured purple, then from the format menu select conditional formatting, leave condition 1 as "Cell value is" from the next drop down select equal to, in the third box type great and then click on the format button and select the format you want -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=390970 |
All times are GMT +1. The time now is 12:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com