Conditional Formatting

[Legault]

I need to have the font in cell D5 appear in red if the amount in cell A1 is greater than 12 and the amount in cell B1 is greather than 6. Both of these criterias have to be met. So far the best that I can do, is to enter this formula, =$A1>12 but I do not know how to extend the formula to include cell B1

Daniel

[BigBas]

=and(a1>12,b1>6)

[Legault]

Thanks BigBAs. It works very good. Can I add something at the end of this formula to enter a comment in cell D5 if the criterias are met.

Daniel

[oldchippy]

You could add this comment to an adjacent cell, but not to Conditional Formatting

=IF(AND(A1>12,B1>6),"Correct","") if both criteria met "your comment", otherwise "blank"