More than 3 conditional formatting excel 2003

Closed
scientist_bob - Jul 2, 2010 at 08:49 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 2, 2010 at 11:20 AM
Hello,

I have the need for more than three conditional formats for rows in a table based on conditions in a specific cell....

PreConditions Condition Data 1 Data 2 Data 3 Data 4
3 left 5 6 2 3
4 right 1 8 2 2
10 top 7 6 10 5
1 bottom 4 9 7 3
9 square 7 9 10 4
9 circle 3 4 2 8
x triangle 4 7 1 5
3 left 9 3 5 10
6 left 10 3 9 4
9 left 4 6 6 4
2 right 5 9 6 3
0 top 10 9 8 0
x bottom 8 4 9 6
8 bottom 2 8 4 1
8 bottom 6 7 1 5
7 square 8 5 9 7
3 square 0 6 4 3
1 circle 9 8 3 9


I am using excel 2003 (yes, I know it's old, but that is what my company is using!) What I need to do is to evaluate the text in column b and then set the color of that entire row to a specific color. For example, if the cell contains "left", I want the row to cell background to turn yellow, if "right", then red, etc. I know that I need to use VBA since there is more than three conditional formats, but don't have the skill to write. I was wondering if someone could give me the correct code that I can then implement in my spreadsheet. Any help would be greatly appreciated.

2 replies

scientist_bob
Jul 2, 2010 at 08:51 AM
sorry table lost its formatting with I posted... supposed to be 6 columns of data and I want to test the criteria in the second column to trigger the color change for the whole row of data
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 2, 2010 at 11:20 AM
0