Easy Conditional Formatting Help

[lemonbug]

Hi-

I would like to color code the cell in column A if the adjacent cell in B = "ABC" and the cell in C < 2.

I know I need to place this in the formula box under conditional formatting, but could someone please help me out with the formula itself?

Thanks, Lb

[Pete_UK]

Try this, with A1 selected and having clicked on Conditional Formatting | New Rule | Use a formula... :

=AND(B1="ABC",C1<2)

Hope this helps.

Pete

[lemonbug]

Thank you kind sir.