stevelucky
Board Regular
- Joined
- Oct 6, 2006
- Messages
- 126
I know how to do what I'm trying to accomplish using Conditional Formatting, but it's WAY too tedious.
Here's the scenario. I have about 60 rows of cells. I want the color of the text in each row to be determined by the value in the first cell of that row. For example, if the value in A1 is "Jon" then the font color in A1-A3 will be blue. But if the value in A1 is "Cindy" then the font color in A1-A3 will be pink. I want the same conditions to apply to all rows, or at least rows 1-60. There will be about 8 different values, thus 8 different colors. Doing this with Conditional Formatting will take FOREVER. I'll have to set the formatting for each value, for each row. 8 values X 60 rows = 480. That's too many time to have to format. Any other ideas?
Here's the scenario. I have about 60 rows of cells. I want the color of the text in each row to be determined by the value in the first cell of that row. For example, if the value in A1 is "Jon" then the font color in A1-A3 will be blue. But if the value in A1 is "Cindy" then the font color in A1-A3 will be pink. I want the same conditions to apply to all rows, or at least rows 1-60. There will be about 8 different values, thus 8 different colors. Doing this with Conditional Formatting will take FOREVER. I'll have to set the formatting for each value, for each row. 8 values X 60 rows = 480. That's too many time to have to format. Any other ideas?