IF/AND/OR using Conditional Formatting

[theatricalveggie]

I'm totally stumped.

I have a spreadsheet where I created a conditional dropdown list.

In cell D25 there is a dropdown with the options A, B, and C. In cell D27 is a second dropdown where the options provided are conditional based on what value is in D25. If D25 = A, then D27 offers 1. If D25 = B, then D27 offers 1 or 2. If D25 = C, then D27 offers 1, 2, or 3. This prohibits people from being offered the wrong number. That being said... I am trying to close a loophole.

You can select C in D25, and then 3 in D27. You can then change D25 to A. A and 3 should not be together.

Normally I'd use Data Validation, but I can't because it has a dropdown in it.

My next idea was use conditional formatting to turn the whole spreadsheet red if someone tries to use the loophole. I wrote this formula, which works in the spreadsheet itself:
=IF(OR(AND($D$25="A",$D$27>1),AND($D$25="B",$D$27>2)),"Format","Don't Format")

However, I can't seem to figure out how to get it to work in Conditional Formatting. I went to New Rules, Use a formula to determine which cell to format, and put for the formula in Format values where this formula is true. Didn't work. Took out the If statement since that sounded inferred. Didn't work. Took out to the True/False values "Format" and "Don't Format." Didn't work.

Stumped!

[Fotis1991]

In Conditional Formatting rules try in this way.

=OR(AND($D$25="A",$D$27>1),AND($D$25="B",$D$27>2))


How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.

[theatricalveggie]

Nope. It accepts the formula, but the cells don't actually format as requested. I am going into the format button and defining how I would like the cells to change. This is so odd.