Conditional Formatting based on 2 cells

S

Shane Clarke

Hi All,

Can anyone help with the following:

=ISBLANK(K17), NOT(ISBLANK(J17))

Basically true if K17 is blank and J17 is not blank.

It must be something simple.

Thanks,
Shane
 
M

Matthew Connor

Shane said:
Hi All,

Can anyone help with the following:

=ISBLANK(K17), NOT(ISBLANK(J17))

Basically true if K17 is blank and J17 is not blank.

It must be something simple.

Thanks,
Shane
Click to expand...
=AND(ISBLANK(K17),NOT(ISBLANK(J17)))

Hope this helps,

Matthew
 
C

Chip Pearson

Shane,


Try something like

=AND(ISBLANK(K17),NOT(ISBLANK(J17)))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

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

Similar Threads

Average from first non-blank cell 13
If Not blank - Formula for two cells 0
Function Error? 3
Keeping cells blank even though formula is input 3
Please help with formula 2
Conditional Formatting based on cell text 3
Conditional formatting based on formula cell 4
Identifying non-returning formula (blank Cell) 9

Top