The second conditional formatting rule could be:

=and(h3="yes",j3="",k31)



PFABA wrote:

I am tryng to create Conditional Formatting with 3 conditions.

1) If J30 then format J3 light blue and stop

But if all 3 of the following conditions are true then format J3 dark blue

1) H3="Yes" (this field with have a "Yes" or "No" in it)
2) J3=0 (blank cell with no text)
3) K31 (this cell will have a 0 or 1 or 2 or 3 etc.)

Thanks for your help!

I

--

Dave Peterson