Formula to color cell if value in two cells are not identical

I have a date value in cell R6 and one in S6. I'd like R6 to be colored red, if the dates in R6 and S6 are not identical. Any suggestions?

Use Conditional Formatting:

Apply formatting using formula: =R6<>S6

- Moo

In case you are not sure how to do the Conditional Formatting:

In Excel 2003:

1. Select cell R6
2. Choose Format|Conditional Formatting
3. From the first dropdown, choose Formula Is
4. For the formula, enter =R6<>S6
5. Click the Format button.
6. Select your desired format (Red cell fill).
7. Click OK
8. Click OK again

- Moo

What about Excel 2007 Moo???

Please help...
Thank you.

Thanks, Moo and ChemistB. Both suggestions worked!

To apply Conditional Formatting in Excel 2007:

1. Select cell R6
2. On the Ribbon, go to the Home tab and click Conditional Formatting
3. Click New Rule
4. Click Use a Formula to Determine Which Cells to Format
5. For the formula, enter: =R6<>S6
6. Click the Format button
7. Select your desired format (Red cell fill).
8. Click OK
9. Click OK again

- Moo

Thank you, fast reply....

really appreciated,

Mihir.

You're welcome. Glad I could help.

- Moo