I'm working in Excel 2002. Is there a way with vba to format and entire row based on the contents of both columns C and D.
If C = "A" and D = "E" then the row color would be 40, light orange and the text bold in black 1.
If C = "A" and D = "P" then the row color would be 35, light green and the text bold in dark red 9.
If C = "X" and D = "E" then the row color would be 39, purple with no text formatting.
I plan on having more than 3 instances so Format>Conditional Formatting won't work.