Conditional Formatting Excel 2008

P

PFABA

I am tryng to create Conditional Formatting with 3 conditions.

1) If J3>0 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) K3>1 (this cell will have a 0 or 1 or 2 or 3 etc.)

Thanks for your help!



I
 
J

JE McGimpsey

PFABA said:
I am tryng to create Conditional Formatting with 3 conditions.

1) If J3>0 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) K3>1 (this cell will have a 0 or 1 or 2 or 3 etc.)

One way:

Select J3. Choose Format/Conditional Formatting...

CF1: Cell Value is greater than 0
Format1: <patterns>/<lt blue>

CF2: Formula is =AND(COUNTA(J3)=0, H3="Yes",K3>1)
Format2: <patterns>/<dk blue>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top