Conditional Formatting - find in a list and if

JLH

New Member
Joined
Jul 28, 2010
Messages
1
I need to conditionally format column U which contains a % value.

Column P and column R contain values which can appear in only one of three lists: hi, med, lo.

What I would like to achieve is (using row 3 as an example but to work on the entire column):
If U3 is blank then no format

If R3 appears in hi then colour U3 red

If R3 appears in med and if P3 appears in hi, and U3<75% then colour U3 red
If R3 appears in med and if P3 appears in hi, and U3>=75% then colour U3 yellow

If R3 appears in lo and if P3 appears in hi, and U3<75% then colour U3 red
If R3 appears in lo and if P3 appears in hi, and U3>=75% then colour U3 yellow

If R3 appears in lo and if P3 appears in med, and U3<75% then colour U3 yellow
If R3 appears in lo and if P3 appears in med, and U3>=75% then colour U3 green

If R3 appears in lo and if P3 appears in lo, then colour U3 green

It sounded simple till I came to write it down. Grateful for any help
- cheers!
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,948
Messages
5,508,314
Members
408,677
Latest member
coffeeman12

This Week's Hot Topics

Top