J
Jman
I need a formula in conditional formating.
I am CF'ing column M.
If column J contains blank cells.... format .
I am CF'ing column M.
If column J contains blank cells.... format .
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Z
zhang
=isblank(j1)
CF:...
CF:...
F
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
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
J
Jman
FSt1 said: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.
D
David Biddulph
Why bother with =IF(...,1,0) ?
What's wrong with =J2="" ?
What's wrong with =J2="" ?
J
Jman
Yeah, this works too.. .Good to know
Thanks.
Thanks.
David Biddulph said:Why bother with =IF(...,1,0) ?
What's wrong with =J2="" ?