Conditional formatting based on a blank cell and a cell with data.

[nickpavlov]

Hello,

I am using this formula in conditional formatting, simple check if a cell is blank.

=ISBLANK($K3)

How can I modify this so it also checks that B3 has any value?

I am looking to do this so I don't have it apply to cells that have not had data entered in as of yet.

Thanks for any help on this.

Nick

[Pete_UK]

Use this formula in the CF condition:

=AND(ISBLANK($K3),$B3<>"")

or slightly shorter:

=AND($K3="",$B3<>"")

Hope this helps.

Pete

[nickpavlov]

Thank you Pete! Perfect.

[Pete_UK]

That's good to hear, Nick - thanks for feeding back.

Pete