excel 2007 - IF Cell A1 = Yes then Fill Red Color in B1 -

I have a worksheet in Excel 2007

If the value of 'yes' in cell A1 is So I want to fill cell B1 in red (despite the content in cell B1).

<

.

Expand Formatting Criteria in Formats , then expand Example 3 .

is available.