Conditional Formatting based on 2 cells

  • Thread starter Thread starter Shane Clarke
  • Start date Start date
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
 
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
 
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)
 
Back
Top