Conditional Formating Formula?

[Jman]

I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .

 

[zhang]

=isblank(j1)
CF:...

 

[FSt1]

hi
may need more detail but.....
formual is.....=IF(J2="",1,0).......format = pukey green. (choose your own.)

post back if that don't work....with more detail.

Regards
FSt1

 

[Jman]

hi
may need more detail but.....
formual is.....=IF(J2="",1,0).......format = pukey green. (choose your own.)

post back if that don't work....with more detail.

This worked perfectly.. Thanks.

 

[David Biddulph]

Why bother with =IF(...,1,0) ?
What's wrong with =J2="" ?

 

[Jman]

Yeah, this works too.. .Good to know
Thanks.

Why bother with =IF(...,1,0) ?
What's wrong with =J2="" ?