Conditional Formatting

[sinspawn56]

Hello.

I am trying to create a formula for conditional formating. In cell B2 i have (a,b,c,d). In array D11:D38 I have the data I want to format. I would like to have a formula that says this.

If B2="a" look through D11:D38 and highlight red everything >85%
if B2="b" look through D11:D38 and highlight red everything >75%

any thoughts?

[martindwilson]

condition 1 =AND($B$2="a",D11>0.85)
condition 2 =AND($B$2="b",D11>0.75)

[sinspawn56]

I am trying to apply the formula to D11:D38 not just D11.

[daddylonglegs]

If the formatting is the same (i.e. red) then you can use a single condition. To apply to the whole range as required you should select that whole range first, i.e. D11:D38 then use the formula that applies to the first cell in the range, i.e.

=D11>IF(B$2="a",0.85,IF(B$2="b",0.75,0))

The formula will automatically adjust for the other cells in the range

[sinspawn56]

Works Thanks!