Conditional Formatting Multiple Criteria

[wmtsub]

I would like to use the conditional formatting feature with a custom formula but can't get it to work.
What I am trying to do is to highlight a cell [d2] if it is less than 10 BUT only if cell [d5] is ALSO under 50.

Would any one be able to assist me?
Thanks

-Eds

 

[Fluff]

is D5 a straight numerical value, or is it a percentage?

 

[wmtsub]

It is a new sheet I created but to be safe I cleared the entire sheet of conditional formatting.
And your rule produces no results.

 

[Scott T]

Make sure you have number in the cells instead of number stored as text.

 

[wmtsub]

it is a numerical value

 

[Fluff]

What is D5 formatted as?

 

[wmtsub]

Number

 

[Fluff]

In that case I cannot think why it doesn't work.

 

[Joe4]

It is a very simple, straightforward rule which should work.
There must be something you are not doing correctly, or some other factor coming in to play.
Are you in cell D2 when you enter the Conditional Formatting rule?

Try going to a blank sheet (or new workbook), and run this VBA code. This will add your Conditional Rule, and values to cell D2 and D10.
You should see cell D2 then turn yellow.

Sub MyCFMacro()

    Range("D2").FormatConditions.Add Type:=xlExpression, Formula1:= _
        "=AND(D2<10,D5<50)"
    With Range("D2").FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
    End With
    
    Range("D2") = "5"
    Range("D5") = "25"

End Sub

If this works, inspect the rule and the values, and see how it differs from what you have been trying.

 

[wmtsub]

Thanks that does the same thing....

 

[Joe4]

Thanks that does the same thing....

What exactly does it do?
It should highlight cell D2 yellow. Does it not?