Conditional Formatting Formula

[THoxsey]

I've been trying to get a conditional format that will highlight a range of cells if D67 is not blank and B67 is blank.

I tried the following and it's not working.

="AND(NOT(ISBLANK(D67)),ISBLANK(B67))"

[AliGW]

Try this:

=AND(D67<>"",B67="")

[THoxsey]

Thank you for the quick response. It worked somewhat... The additional item I need to have cells B67-F67 turn color if the condition is met. Right now just B67 turns color when condition is met.

Formula: =AND(D67<>.... turn red Applied to =$B$67:$F$67 Stop if True is checked

[AliGW]

Have you set the scope of the rule to the entire array?

$B$67:$F$67

You will also need to change the rule to this:

=AND($D67<>"",$B67="")

[THoxsey]

Yes, I have the array set up and it still only highlights B67

[AliGW]

You can't have it set up correctly, then. How about attaching the file here? I'll have a look for you.

[THoxsey]

I am very new to this and I responded to your email with an attachment but not sure if that was the correct way to send the attachment. If not, please explain how to attach a file in the Thread.

[AliGW]

I haven't contacted you at all via E-mail or via a private message, so who have you sent it to?

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[THoxsey]

I have uploaded the file and I see it on the screen as being uploaded. I did not see any instructions on how to attach to this tread.

[THoxsey]

I am hoping this worked.

[AliGW]

I can't help without knowing the password.

[THoxsey]

Sorry..... "2018" is the password.

[AliGW]

I think the rule was the wrong way round. Try this:

=AND($B67<>"",$D67="")

[THoxsey]

Yea.... That worked.... Thank you very much...

[AliGW]

Glad to have helped!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.