The conditional formatting feature does not allow more than 3 sets of conditions and I want to format greater than 3. I want to make an entire row a specific color, when I make any one cell in that row a certain condition. For example, if any cell equals "apple" make that row red. If any cell equals "pear" make that row blue. There are more than 3 conditions. You may need to use visual basic programming. How can you do this? Thanks for helping.