Conditional Formatting of rows > 4 conditions

[Jammer]

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.

 

[Legacy 98055]

Hi Jammer. I can almost guarantee that you will get a great example if you will post some details. Which cells, when what = what. Ect...
Tom

 

[dennisdjones]

Hey, got this code from "Mudface"! Great guy.

See the link below where he worked it out for me. Good luck! Try the link below. Select, copy, paste. (if not work as hyper)

http://216.92.17.166/board/viewtopic.php?topic=9023&forum=2

 

[dennisdjones]

PS: REMEMBER CaSe sENsitIve

colors

APPLE = 3 (red)
BANANA= 6 (yellow)
PEAR = 4 (green)

 

[rikrak]

On 2002-10-01 15:14, dennisdjones wrote:
PS: REMEMBER CaSe sENsitIve

colors

APPLE = 3 (red)
BANANA= 6 (yellow)
PEAR = 4 (green)

Hi Dennis,

Are you refering to this code you got from Mudface?
If UCase(Target) = "e" Then Target.EntireRow.Interior.ColorIndex = 3
If UCase(Target) = "E" Then Target.EntireRow.Interior.ColorIndex = 3

If so, i don't understand your message "PS: REMEMBER CaSe sENsitIve". Can you explain it to me?

I think 1 line of code will do:
If UCase(Target) = "E" Then Target.EntireRow.Interior.ColorIndex = 3

 

[Jammer]

Thank you to everyone who has helped. I am learning Visual Basic (really a beginner) and will try out everyone's helpful suggestions.