More than 3 conditional formatting excel 2003

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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


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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768