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
 
Top